Populating a table with Report names

[shaunacol]

Is it possible to populate a table with just the names of all the reports in your database?

I have loads of reports and typing their names into a table could take a while...

Thanks

 

[MichaelRed]

Depends on what 'a while' means as to wheather it would be faster. Programmaticaly would certainly be more accurate and easier to maintain.

There are a few ways to accomplish this. Probably the easiest is the use ot the 'hidden' table MSysObjects. It has a wealth of information re EVERY object in the Ms. Access database. One of the fields is the object name, and another is it's "type". The tyupe does NOT correspond to the intrinsic types normally used to direct Ms. Access to reference a specific document category, but they are not very hard to "decode". Just start with a query which selects everthing from a table "MSysObjects" ("Select MSysObjects.* From MSysObjects;&quot. Follow the yellow brick road, and You should arrive safely at the Capital of Report names.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over