print a list of reports in access

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

Guest

Does anyone know of a way to print a listing of all your reports in the
Reports Object section.
 
just go

tools->analyse->documenter

You can print out all information about the reports.

Play with the "options" button, as these documenter printouts tend to be
very large....
 
Albert D. Kallal said:
just go

tools->analyse->documenter

You can print out all information about the reports.

Play with the "options" button, as these documenter printouts tend to be
very large....


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)


Thank you. I tried that but it gives all the detail. I was just interested in the names, but I will take your suggestion and play with the options button. Thanks again.
Click to expand...
 
Thank you. I tried that but it gives all the detail. I was just
ah...ok....

Even if you turn off all options, you still get one page per reprot....

If you just want a quick list, then just type in the follwing code into a
module.

Sub ShowReprots()

Dim i As Integer

For i = 0 To CurrentProject.AllReports.Count - 1
Debug.Print CurrentProject.AllReports(i).Name
Next

End Sub

just hit f5 to run, and you can then cut/paste the list of reprots into
word, or whatever....
 
You could also create a query based on the MS Sys object table and filter
this to the report options

1. Create a query based on the ms sys objects table
2. drag the appropriate fields to the grid
3. look for a familiar name in the field regarding the reports
4. in the criteria field place the ID number for reports

create your output (report) based on this query

ps To do this your systems tables should be set to visible...
 
Or you can use the following query:

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