How to check if a query is hidden from within a VBA module?
Posted on 2006-07-19
I am building up a table of all queries that are in my database. I don't want to list hidden queries, but I cannot find a way of checking for hidden queries within the code. Any ideas?
This is the snippet of code I use to go through the CurrentData's AllQueries collection:
' go through all the queries
For Each aob In CurrentData.AllQueries
' get the name and type
rst!objName = aob.Name
rst!objType = "Query"
intNum = intNum + 1
rst!objNo = intNum
' is it hidden?