Identifying Hidden Queries

[Shankspony]

Good morning all...

I am attempting to programmatically identify queries hidden from view in MS Access 2010. I understand that there is a hidden attribute (accessibly through the UI by bringing up the properties of the query and VBA with GetHiddenAttribute). That I can handle.

There is another setting which is 'hide from this group' (right click menu) and I can't seem to find the property or attribute with VBA. I have looked extensively through the object hierarchies and local variable/object components too. Is there any wisdom out there on this subject?

I am hoping this is one of those instances where I just don't know the word/terminology to search for.

 

[strive4peace]

perhaps this will get you on the right track ...

.1. make a new query
.2. switch to SQL view
.3. paste this SQL:

SELECT DISTINCT MSysObjects.Name AS QryName, MSysObjects.Flags, MSysObjects.Type
FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId
ORDER BY MSysObjects.Name;

 

[Shankspony]

Thank you, Strive... I wish it did but I can't find discernible information relating to the visibility of the querydef in the group.

 

[Shankspony]

I even tried toggling the hidden status of some of the queries to compare results before and after. No changes noticed. I was hoping Type 5 with flag would be the winner but it isn't.