Query of Non-Hidden Queries

  • Thread starter Thread starter Samer
  • Start date Start date
S

Samer

I would like a list of all my queries, excluding those that are
hidden. Is this possible?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exclude items in a query 2
query excluding listings from table 2
WHERE mystery 2
Access Remove rows based on multiple fields 2
Query criteria - exclude data and return all records if null 3
Counting multiple memberships 1
NOT expression in a Query 3
Create query to merge 2 tables? 2

Back
Top