How To Create a List of Reports, Queries or Tables in Microsoft Access
erics, February 25th, 2012 This query will list the names of the reports in the database: SELECT MSysObjects.Name AS Report_Name FROM MSysObjects WHERE (((MSysObjects.Type)=-32764)) ORDER BY MSysObjects.Name; This query will list the names of the queries in the database: SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5)); This query will list the names of the tables in the database: SELECT MSysObjects.Name […]
Categories: How-To's, Technology Access, Export, howto, MS Access, Queries, Query, Reports, tips
| 
No comments
