View Full Version : Display hidden query?


romanticode
01-17-2008, 04:07 AM
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
01-17-2008, 04:28 AM
Go to menu > window > click unhide.


Hth

romanticode
01-19-2008, 10:07 PM
not working unhide menu not active even i've hide some queries.

boblarson
01-19-2008, 10:19 PM
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.