Names of all objects

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are trying to right a small utility that will return a list of all objects
in a database -- queries, tables, forms, reports, macros, modules.

In application.Currentproject, I can get to "AllReports", "AllForms",
AllMacros", "AllModules", but there is no option for tables of queries.

Is there another way I can do this? Thanks.
 
In
KarenH said:
We are trying to right a small utility that will return a list of all
objects in a database -- queries, tables, forms, reports, macros,
modules.

In application.Currentproject, I can get to "AllReports", "AllForms",
AllMacros", "AllModules", but there is no option for tables of
queries.

Is there another way I can do this? Thanks.
Click to expand...

In addition to the approach Klatuu suggested, you can go to the
CurrentData object, instead of CurrentProject, for AllTables and
AllQueries.
 
KarenH said:
We are trying to right a small utility that will return a list of all
objects
in a database -- queries, tables, forms, reports, macros, modules.
Click to expand...

You *are* aware that the documenter will printout all this stuff for
you...right?

tools->analyze->documetor
 
Back
Top