Printing list of query, forms and reports

[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.

 

[fredg]

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.

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