View Full Version : Print Lists of Forms, Tables, Reports, etc.


kermit5
11-30-2001, 09:21 AM
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
11-30-2001, 09:56 AM
Have you tried the Documenter? Tools-Analyze-Documenter. This will allow you to select what you want to see and document.

Pat Hartman
12-01-2001, 07:00 PM
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
12-01-2001, 08:02 PM
You will find a nice little documentor here:
http://www.liquorman.net/