Hidding a query through code

[Rafael Baltresca]

Hello all.
There's a attribute called (hidden) in the queries. It's
easily accessed just by clicking in a query and then
View/Properties.

I need to hide/unhide a query through code. How can I do
this ?

Thanks, Rafael.

 

[John Viescas]

Use:

Application.SetHiddenAttribute acQuery, "<query name>", True

and use:

Application.GetHiddenAttribute

To find out the hidden status of an object.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411