Names of all objects

[KarenH]

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.

 

[Klatuu]

You want CurrenDb.TableDefs and CurrentDb.QueryDefs

 

[Dirk Goldgar]

In

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 addition to the approach Klatuu suggested, you can go to the
CurrentData object, instead of CurrentProject, for AllTables and
AllQueries.

 

[Albert D. Kallal]

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.

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

tools->analyze->documetor