Export a List of Reports in Microsoft Access

[Connie]

I have an Access application which contains many reports(100+). I'm
trying to get a list of the reports without having to manually look in
the application to make the list. Is there a way to export a list of
the reports with, perhaps, the fields utilized by the reports?

 

[Jeff Boyce]

Connie

Have you looked into using the built-on documenter?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jerry Whittle]

This query will list the names of the reports in the database.

SELECT MSysObjects.Name AS ReportName
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;

 

[Connie]

This query will list the names of the reports in the database.

SELECT MSysObjects.Name AS ReportName
FROM MSysObjects
WHERE (((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.





- Show quoted text -

I created the query and it worked. Thank you so much.