Display hidden query?

[romanticode]

i accidentally change a property of a query to hidden, i don't know how to make the query displayed again.

what should do?

 

[Ron_dK]

Go to menu > window > click unhide.


Hth

 

[romanticode]

not working unhide menu not active even i've hide some queries.

 

[boblarson]

Actually, you will need to go to:

For Access 97-2003 -
TOOLS > OPTIONS > VIEW TAB > HIDDEN OBJECTS checkbox

For Access 2007
Right Click on the Navigation Window (Database Window) and select NAVIGATION OPTIONS and then Select HIDDEN OBJECTS checkbox

Then, once you have checked the HIDDEN OBJECTS checkbox you should be able to see the query as a dimmed out object. You can then right-click on it and uncheck the HIDDEN checkbox.

Then, go back and uncheck the HIDDEN OBJECTS checkbox to enable hidden objects again.