[AccessD] Write Array to Table

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu Feb 28 16:41:48 CST 2008


Dear List:
 
Is there a quick way to write the contents of an array out to a table.  I
need to see the contents of this array and debug is too awkward.  A table
view would be ideal.
 
The array is DIMmed as:
 
Dim mudTH() As THRecord
 
where THRecord is 
 
Private Type THRecord
    TaskID As Long                  'T
    StartDate As Date               'S
    DueDate As Date                 'D
    QuasiDueDate As Date            'Q
    TargetDate As Date              'R
    RequiredHours As Double         'H
    EarliestCompleteDate As Date    'C
    ASAP As Double                  'A
    fOrdering As Boolean            'F
    ErrorHours As Double            'E
    TempReg As Double               'Z
    DueDateFlag As Boolean          'FD
    PastDueFlag As Boolean          'FP
    ASAPFlag As Boolean             'FA
    TargetDateFlag As Boolean       'FT
End Type
 
So if necessary, I could make a table with the required number of fields.
 
MTIA
 
Rocky
 

 



More information about the AccessD mailing list