Print Lists of Forms, Tables, Reports, etc.

[kermit5]

Is there a way to print a list of objects in by database? I would like to print it to a printer and also to a file usable in another application such as powerpointe.

 

[mrssevans]

Have you tried the Documenter? Tools-Analyze-Documenter. This will allow you to select what you want to see and document.

 

[Pat Hartman]

If you want just a simple list, you can write a query that selects the information from MSysObjects (a hidden system table). The following is a list of some of the object types. If you find that your database has additional object types just add them to the lookup table.

Type	Description
-32768	Forms
-32766	Macros
-32764	Reports
-32761	Code Modules
1	Local Access Tables
3	system stuff
4	Attached ODBC Tables
5	Queries
6	Attached Access Tables

 

[Jack Cowley]

You will find a nice little documentor here:
http://www.liquorman.net/