Export a List of Reports in Microsoft Access

  • Thread starter Thread starter Connie
  • Start date Start date
C

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?
 
Connie,

Have you tried the Documenter? In Access 2003 it is located via
Tools=>Analyze=>Documenter.
 
Connie,

Open a query to SQL view and copy/paste the below in the window...

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.ParentId)=-2147483645));

Do NOT change any of the names of *anything* as this is an internal table
used by Access. Close and save and export it to Excel.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

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?
 
Back
Top