Query List of All Reports

[jason]

I've been able to create a table with my report names, then on a form I have
a combo box that pulls those report names from the table, and finally a
button that opens the selected report.

Well this seems like a long way around. Is it possible to automatically pull
all report names in a query without having to manually add these to a table.
This way, when my user creates a new report, they don't have to add that
report name into a table.

Any help appreciated.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), are two small Access databases
sample called "ChooseReportFromList.mdb" and "ChooseReportFromList2.mdb"
which illustrate how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jerry Porter]

Try:

SELECT [Name]
FROM MSysObjects
WHERE Type = -32764
ORDER BY [Name]

 

[Douglas J. Steele]

You can use the undocumented (and usually hidden) MSysObjects table:

SELECT Name
FROM MSysObjects
WHERE Type=-32764
ORDER BY Name

If you're not comfortable working directly with SQL, you can temporarily
unhide the system tables under Tools | Options, and build your query through
the normal GUI.

 

[jason]

Thanks for the responses.
I used the MSysObjects table and worked fine. Although I had to unhide the
tables in order for it to work in the form.

Thanks.