 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007print a list of reports in access
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....  SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com > just go > [quoted text clipped - 4 lines] > Play with the "options" button, as these documenter printouts tend to be > very large.... >> 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. 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... SignatureMaurice Ausum > >> 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 [quoted text clipped - 19 lines] > just hit f5 to run, and you can then cut/paste the list of reprots into > word, or whatever.... Or you can use the following query: SELECT [Name] FROM MSysObjects WHERE [Type]=-32764 ORDER BY [Name] SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >>> 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 [quoted text clipped - 19 lines] > just hit f5 to run, and you can then cut/paste the list of reprots into > word, or whatever.... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.