Query of Non-Hidden Queries

  • Thread starter Thread starter Samer
  • Start date Start date
Have you tried using a Screen Print when Access is open to the Queries?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
SELECT MSysObjects.*
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*"
Or (MSysObjects.Name) Like "MSYS*")
AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;

The above query will not return queries with names starting with either ~ or
MSys. The ~ queries are those SQL statements used for the records source for
forms and reports. I guess you could call them 'hidden'. Anything that starts
withMSys is considered a System object and also 'hidden'. I don't know of an
easy what to tell which objects that you have set their properties to hidden.
 
Back
Top