Printing a list of database objects

R

Robert

I need some help in printing a total list of a particular
database object. I have over 100 queries and I would like
to print out a list of their names for review. How do I
do this ? Thanks.
 
A

Allen Browne

There is a built-in documenter:
Tools | Analyze | Documenter

Alternatively, this query will give you a list of your query names:
SELECT MSysObjects.Name FROM MsysObjects
WHERE ((MSysObjects.Type = 5) AND ([Name] Not Like "~*"))
ORDER BY MSysObjects.Name;
 
J

Jeff Conrad

Hi Robert,

In addition to Allen's suggestion of using the built-in Access Documentor, you may want to try my
new "Doug Steele Object Documentor" Add-In. This add-in will create a nice report of all your
database objects for easy reference. The report will list all the objects by category in
alphabetical order in a three-column layout. It looks very sweet in my opinion and it's even easier
to use than the Access Documentor. Plus, you get a nice report saved in your database that you can
open again any time you wish.

I just checked this morning and it looks like Doug just added it to his web site this week!
Here is the link:

http://members.rogers.com/douglas.j.steele/Documentor.html

Hope you like it!
 
Top