Subject: Enumerating the reports collection
Posted By: dmoffice Post Date: 8/29/2006 2:51:38 PM
I want to list the reports, or better document, of about 100 MS Access Applications/ databases and make a table of those reports with db references. How?

David
Reply By: dmoffice Reply Date: 8/29/2006 2:53:18 PM
I have successfully listed the tables used.

David
Reply By: BrianWren Reply Date: 8/29/2006 3:25:22 PM
There is a Reports collection.  To wit:
    Reports.Count
    Reports.Item(1).Name
Open each database in code as a DataBase object, and read its Reports collection, storing what you find in a table in the database holding the running code.  Or you could have a second DataBase object, keeping it open for the whole operation, storing your results within a table therein.

Go to topic 48494

Return to index page 190
Return to index page 189
Return to index page 188
Return to index page 187
Return to index page 186
Return to index page 185
Return to index page 184
Return to index page 183
Return to index page 182
Return to index page 181