In Access 2007, the way of configuring things have been dramatically changed by Microsoft. To unhide a query (or any other Access objects), you need to use the Office Button.
1. Click the Office Button at the top left corner of Access window.
2. Click Access Options button.
3. Click Current Database tab on the left hand side navigation menu.
4. On the Current Database tab, click Navigation Options button.
5. On the Navigation Options window, tick the checkbox Show Hidden Objects in the Display Options section.
6. Click OK to close all the windows.
7. Go back to the navigation pane to view the queries. You should see the query name "Quarterly Orders by Product" is now grayed out but still viewable.
8. If you need to see the query again as a normal query (ungrayed), right click on the query and untick the checkbox Hidden on its Properties windows.
Note that all the steps shown above can also be applied to other Access objects like Tables, Reports, Forms, Pages, Macros, and Modules.
Happy Hiding and Unhiding!
Copyright© GeeksEngine.com
