|
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.
|