How to hide and unhide a MS Access object



You can hide and unhide a MS Access object (Tables, Queries, Forms, Reports, Pages, Macros, Modules) in the query navigation pane. It's a similar feature like what you do in MS Excel to hide and unhide a spreadsheet.

There are various reasons why you want to hide and unhide an Access object. You may work on an Access database that was developed by someone else and you'd like to know if there are any hidden tables or queries and how to view them.

On the other hand, when you develop a MS Access database application, sometimes you may consider hiding some queries in the navigation pane and later you may want to see it back or unhide them. In this article, we are going to demo how to hide and unhide an Access query.

How to hide a query in Access

For hiding a query, it's similar across all the Access versions, Access 97, 2000, XP, 2003, 2007, etc.

Below are some screenshots for Access 2003 and Access 2007 for hiding the query "Quarterly Orders by Product" in Northwind database.

1. Open Properties window.

Access 2003: In the Queries pane, right click on the query name "Quarterly Orders by Product" and select Properties in the pop-up context menu.

Access 2007: In the navigation pane, right click on the query name "Quarterly Orders by Product" and select Object Properties in the pop-up context menu.

2. Then in the properties windows, tick the checkbox Hidden.

3. Click OK button. Now the query "Quarterly Orders by Product" should disappear from the Queries list.

How to unhide a query in Access 97, 2000, XP, 2003

1. Go to Tools -> Options on the menu bar.

2. Click the View tab and check Hidden objects in the Show section.

3. Click OK.

4. Go to the Queries pane to view all the queries. The hidden query should now be displayed but its icon is grayed out.

5. If you need to show the query so that they can be displayed as normal (not grayed out), right click on the query name and uncheck the checkbox Hidden so effectively you change the option back to unhidden.

How to unhide a query in Access 2007

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

Other Recent Articles from the MS Access category: 1. Examples of MS Access DateDiff function used in query and VBA code 2. MS Access DateDiff function 3. How to find out your computer name and username by VBA 4. Examples of MS Access DatePart function 5. MS Access DatePart function 6. Examples of MS Access DateAdd function 7. MS Access DateAdd function 8. IIF function basics - the CASE statement of MS Access 9. MS Access Date Expression 10. Solved: MS Access error "The text is too long to be edited" 11. Create MS Access Combo Box essential properties by VBA code 12. Create MS Access Combo Box essential properties manually 13. How to do text search in MS Access programmatically 14. Solved - the size of the Access query result is larger than the maximum size of a database (2 GB) 15. How to easily get a list of field names in MS Access 16. How to count distinct records in MS Access 17. How to do transaction based processing in MS Access 18. How to open a document (local/network file or web page) from MS Access 19. How to use ADOX to create unique composite index - the VBA approach 20. How to do cross-table update queries in MS Access - the right way 21. Three efficient ways to get the number of records by using VBA 22. How to create a composite unique index (not as a primary key) in MS Access 23. Use VBA to get the correct number of records in a Recordset object 24. Disable Access Prompt when a record is changed, table deleted, or action queries run 25. How to return multiple values from a VBA function (Part 3) 26. How to return multiple values from a VBA function (Part 2) 27. How to return multiple values from a VBA function (Part 1) 28. Three ways to programmatically duplicate a table in MS Access by VBA 29. Create a DLL by CSharp or VB.Net for VBA 30. How to correctly reference and call a DLL 31. How to register a C# or VB.Net DLL 32. Email address validation by Regular Expressions using VBA 33. Fix MS Access error: Query must have at least one destination field 34. How to unselect radio buttons in MS Access after it has been selected 35. How to Change Query Timeout Value for MS Access SQL Queries 36. What is Northwind Traders database