Printing list of query, forms and reports

  • Thread starter Thread starter David Kennedy
  • Start date Start date
D

David Kennedy

Is there a way to print out a list of queries, forms and
reports. I need just the names. I use access 2000 in
windows 2000 environment.
 
Is there a way to print out a list of queries, forms and
reports. I need just the names. I use access 2000 in
windows 2000 environment.
Click to expand...

I threw in Tables for good measure.

for just the object names. make a Query:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],4))<>"MSys") AND ((MSysObjects.Type)=1)) OR
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) OR
(((MSysObjects.Type)=-32768)) OR (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Type, MSysObjects.Name;

Make a report using this query as record source, or just print the
query.

If you need more information about the objects, i.e. properties, etc.,
Click on:
Tools + Analyze + Documenter
 
Back
Top