Fred,
Yes, just the Name of the query.
I had a little trouble following your instructions:
1) Create new report
- Check
2) As Report Record Source write...
- I am not familiar with reports, how do I add a Report Record Source?
Thanks,
Lou
fredg said:
On Wed, 26 Jul 2006 10:58:02 -0700, Lou Sanderson wrote:
Access 2003
Windows XP
I would like to print the names of all the queries I have in my Access
database. Right now the only way I can think to do this is via a screen
capture.
Anyone know of another way I can print out a list of all the queries I have
in my database?
Just the Name of the query?
Create a new report.
As Report Record Source write:
SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
MSysObjects.Name;
Add the Name field to the report detail section.
Run the report.
Did you check out the built-in Access Documenter?
Tools + Analyze + Documenter
On the main database folder, select Reports.
Click on New.
A dialog box will open. Select Design View.
Do NOT enter anything in the Choose the table or query box.
Click OK
When the report in design view opens, right-click on the little square
where the upper and left side ruler's meet (or click View + Properties
from the Menu tool bar).
Select Properties.
Click on the Data tab.
The first line is the report's record source line.
Directly on that line write (all on one line):
SELECT MSysObjects.Name FROM MSysObjects WHERE
(((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5)) ORDER BY
MSysObjects.Name;
Close the properties box.
Then click on the field list tool button (it looks like a piece of
paper with writing on it).
Select and then drag the Name field onto the report detail section.
You can delete the label that is attached to the text control.
Save and run the report.