Query of Non-Hidden Queries

S

Samer

I would like a list of all my queries, excluding those that are
hidden. Is this possible?
 
J

Jeff Boyce

Have you tried using a Screen Print when Access is open to the Queries?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

Jerry Whittle

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.
 
Top