printing - query list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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:
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
 
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:
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.
 
Fred,
Mission accomplished. Thank you
-Lou

fredg said:
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.
 
Screen capture seems to be the quickest and simplist method.

If you wnated to put the names in a word doc or an excel spreadsheet, you
can click on the name pause and click on the name again which puts you in
edit mode for changing the name of the query, report, table etc. Then Ctl c
and past into the doc or xls.
 
Back
Top