List of DB Objects

[Jared]

I'm trying to find a way to create a list of my DB's
objects in the table. I have seen in the Knowledge Base
that there are two ways to list the object names. One, by
using DAO and the name shows one at a time in a msgbox.
Second, by using Listbox Control. This one I more along
the lines of what I want. Since, the Listbox is limited
to 2,048 characters, it doesn't work for my DB because of
the number of Queries and Macros I have. I really would
like to have the object names be put into a table. Does
anyone have any ideas?

Thanks for your time,
Jared

 

[John Vinson]

I'm trying to find a way to create a list of my DB's
objects in the table. I have seen in the Knowledge Base
that there are two ways to list the object names. One, by
using DAO and the name shows one at a time in a msgbox.
Second, by using Listbox Control. This one I more along
the lines of what I want. Since, the Listbox is limited
to 2,048 characters, it doesn't work for my DB because of
the number of Queries and Macros I have. I really would
like to have the object names be put into a table. Does
anyone have any ideas?

Thanks for your time,
Jared

Take a look at the MSysObjects table. It's hidden; you can use
Tools... Options and check the "Show System Objects" to reveal it.
There are (undocumented but easy to figure out) codes in the Type
field identifying forms, reports, etc; and the Name field contains the
name of the object. Run an Append query to populate your table.

There is also the option of using Tools... Analyze... Documentor.

 

[Guest]

-----Original Message-----


Take a look at the MSysObjects table. It's hidden; you can use
Tools... Options and check the "Show System Objects" to reveal it.
There are (undocumented but easy to figure out) codes in the Type
field identifying forms, reports, etc; and the Name field contains the
name of the object. Run an Append query to populate your table.

There is also the option of using Tools... Analyze... Documentor.


.
Thanks a lot John. This helps out a lot!

Jared