Hello All,

I am populating a list box with all the queries in a database. I want to remove the hidden ones from this list as they have no use to be displayed in here.

Could someone help me out with the syntax to find out the hidden properties of a query.

any help would be mush appreciated

Do you want the fish? Or do you want to learn to fish?

Here's the fish:

Application.GetHiddenAttribute(objecttype,objectna me)

How to fish... (since I didn't know the answer until I went fishing)

Go to VBA.
Press F2 (this opens the Object Browser).
Type hidden (or whatever you're looking for), in the search box.
Check the results for something that looks useful and try it. (Maybe backup your database first... just in case you find something that will really trash it.)

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org