How To Create a List of Reports, Queries or Tables in Microsoft Access
erics, Posted February 25th, 2012 at 9:48:59am
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
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like 'MSys*') AND ((MSysObjects.Type) In (1,4,6)));
Categories: How-To's, Technology Access, Export, howto, MS Access, Queries, Query, Reports, tips
Leave Your Comment
All fields marked with "*" are required.