How do you set a query to be hidden in VBA?

[monsjic]

I know how to do this to tables, but I can't get it to work for queries. How can I set the query attributes of hidden to be true?

Thanks

 

[KyleS]

Hi monsjic,

Why do you want to hide the query? If it's an action query you won't see anything at all, so you would only need to hide a select query?

 

[jimmythegeek]

Are you talking about the confirmations of an action query? Like "You are about to delete 150 records from the orders table, do you wish to continue?"

If so, you can do this:

==========
DoCmd.SetWarnings False
DoCmd.OpenQuery "YourQuery"
DoCmd.SetWarnings True
==========

OR, I recommend this instead, becuase SetWarnings will eliminate any response from the database, even an error you may want to see. Where as the SetOption only affects the action queries.

==========
Application.SetOption "Confirm Action Queries", False
DoCmd.OpenQuery "YourQuery"
Application.SetOption "Confirm Action Queries", True
==========

Don't know if that's what you are looking for or not. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[esakal]

i understand that you would like to hide the query for security metters.

i know how to change the attribute for tables and i'll try to do so for queries.

i'll let u know if i'll find a way... :>

esakal

 

[monsjic]

I want to hide them because I like the added security. I do not want to supress confirmations(i.e. set the warnings to false).

 

[monsjic]

Anybody have any more ideas?

 

[jebry]

Hi!

I'm using A2K and when I right click on a query and choose properties, one of the attributes is hidden. If I check the box the query is hidden. Does that help?

Jeff Bridgham
bridgham@purdue.edu

 

[monsjic]

I want to be able to change the hidden attribute property programatically using VBA. As I stated before, I do not want to supress warning messages.