Fields Collection

[oliver_penney]

hmm, i'm confused, in this code:-

Sub test9()
Dim loopy As Fields

For Each loopy In DBEngine.Workspaces(0).Databases(0).TableDefs("tbl_Exchange").Fields
MsgBox (loopy.Name)
Next
End Sub

it works if i dont declare loopy as a field, but leave it to go as a variant

but surely the objects in hte fields collection are fields?

??

oliver

 

[oliver_penney]

hold on, think i got it i need

dim loopy as dao.field

*doh*