Question: In Microsoft Access 2010, how do I display all of my queries in the Navigation Pane? In Navigation Options dialog box, under Display Options, enable Show System Objects option and click OK. Question: In Microsoft Access 2010, how do I display all of my modules in the Navigation Pane? Microsoft Access / VBA Forums on Bytes. To show or hide the Navigation Pane in Access web apps, follow these steps: To display the Navigation Pane in an Access web app, on the Home tab, in the Show group, click the Navigation Pane toggle button. Here list two ways to seek for Navigation Pane in Microsoft Access 2010: Familiar way to get Navigation feature if you have Classic Menu for Office. Now the Navigation Pane should display … ... And then you should search on "MS ACCESS 2010 custom ribbons" using your favorite engine. Access 2010. F11 only exposes and hides the Navigation Pane. ICT Training, Maxwell School of Syracuse University Page 4 Tip: To search the whole database for a specific object, select one of the predefined categories in the Navigation Pane, such as Tables and Related Views or Object Type. To hide the Navigation Pane, click along the top of the Navigation Pane, click the Navigation Pane toggle button, or press F11. Thanks HTC, Using Access in runtime mode prevents anyone from seeing the navigation pane, which is the desired effect. We protected each form with login and password so the user can only access his/her records in a form (using vba macro inside MS-Access). 1. With the Navigation Pane in view I was never able to make the little left-right expansion arrow appear using the mouse, which would have allowed me to expand the pane. To Open the Access Option window. We are working on a project in MS-Access 2010, where users will be using switchboard as a main menu for navigation and will work in forms. Now the Navigation Pane should display all of the forms that are in your database. I am using Access 2016. Use Customize Quick Access Toolbar to Display Navigation Pane. Question: In Microsoft Access 2010, how do I display all of my forms in the Navigation Pane? Answer: To view the modules in the Navigation Pane, click on the Navigation Pane menu and select "Modules" from the popup menu. It's a dozy! I need the navigation pane to be hidden when access is not set to runtime mode as well (for those savvy enough to work out how to change the extension back, or find the target of the shortcut), and have adjusted my code in the following way: MS Access Navigation Pane Hide/Show VB code. By default, Access 2010 doesn’t show system objects, however, you can enable them from Navigation Options. Handout: Access 2010 The Navigation Pane Topics came directly from Microsoft Access 2010 Help. Tried RunMenuCommand / WindowHide but it did not work. Well, it hid the Nav Pane but then I tried a macro to RunMenuCommand / WindowUnhide and put it on the Quick Access Toolbar and it DID NOT WORK. Need to show and hide the Navigation Pane with code or a macro. You will need to press F11 again to show the Navigation Pane. Can write code if I knew the commands to use. Answer: To view the queries in the Navigation Pane, click on the Navigation Pane menu and select "Queries" from the popup menu. Now the Navigation Pane should display all of the queries that are in your database. Oh, BTW, I can bypass everyone of these actions quite easily; thus, the more savy users will figure it out. I tried the following: Held down the Shift key while opening the database. This method can be used only when you see the Customize Quick Access Toolbar icon on top of menu bar as shown in the picture below. Answer: To view the forms in the Navigation Pane, click on the Navigation Pane menu and select "Forms" from the popup menu. Please help. To show all the system objects, right-click in main navigation pane and select Navigation options.