Enumerating the reports collection

dmoffice · August 29th, 2006, 02:51 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

dmoffice · August 29th, 2006, 02:53 PM

I have successfully listed the tables used.

David

BrianWren · August 29th, 2006, 03:25 PM

There is a Reports collection. To wit:

Code:

    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.