Query,Field,Table, Lists Function

[bblekfeld]

Can I get a list of queries, fields, table, etc from Access without running that report. Meaning, is there a function that returns a list of queries fields, tables etc?


The report is too cumbersome and requires so much formatting, I just need a simple list.

Thanks!!

 

[SkipVought]

bblekfeld,

Have a look at these and you'll find more, I am sure...

Sub testt()
   With CurrentDb
      For Each td In .TableDefs
         MsgBox td.Name
         For Each fl In td.Fields
            MsgBox fl.Name
         Next
      Next
      For Each qd In .QueryDefs
         MsgBox qd.Name
      Next
   End With
End Sub

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884