Topics Search

Hide the Navigation Pane in Access 2007

Hide the Navigation Pane in Access 2007
Views: 401
Starting in Access 2007, the traditional database window has been replaced with a window on the left-hand-side called a Navigation Pane.
There are different ways that the Navigation Pane can be hidden in Access 2007. We'll go through the options from the easily method to the most difficult.
Sponsored Links:

More topics

 

Hide Navigation Page using VBA

Preview
I would like to expose the Navigation Pane when I run an MS Access 2007 database but hide it when other users run it.

I was hoping for

Application.SetOption "Hide Navigation Pane", true/false

But Access doesn't like this. What is the code I should use?
 

Show or hide the Navigation Pane

Preview
By default, the Navigation Pane appears when you open a database in Microsoft Office Access 2007, even if the database was created in an earlier version of Access. In an open database, you can hide or show the Navigation Pane at any time. You can also set the default option in an open database so that the Navigation Pane does not appear the next time the database is opened.
 

keep navigation pane locked after link table

Preview
I don't want users to have access to the navigation pane in a 2007 app. I have the option to show the navigation pane unchecked, but that doesn't hide it. So, I'm locking the navigation pane when the main form opens with this code:

DoCmd.LockNavigationPane True

From time to time, the app will create a new table in a remote mdb and then link to that table with:

DoCmd.TransferDatabase acLink, "Microsoft Access", DbPath, acTable, strTblName, strTblName

When that occurs, the navigation pane becomes visible. How can I permanently lock the navigation pane as I could in previous versions of Access
 

Display/Unhide the Navigation Pane in Access 2007

Preview
Starting in Access 2007, the traditional database window has been replaced with a window on the left-hand-side called a Navigation Pane.
There are different ways that the Navigation Pane can be hidden in Access 2007. As a result, there are also different methods for displaying a hidden Navigation Pane. We'll go through the options from the easily method to the most difficult.
 

Navigation Pane won't hide

Preview
I have been trying to hide the navigation pane in my FE. I have unchecked the "Display Navigation Pane" in the Access Options but Alas, it is still there. It is an annoyance to myusers who don't need it how do I keep it from appearing?
 

password for navigation pane

Preview
I have created a database being used by around 50 people. for security of forms and queries, I can hide the navigation pane through the office button > access options > current database > uncheck Display Navigation Pane. however, I need 3 people to have access to the navigation pane to be able to edit tables and create/edit queries. is there a way to set-up a password to activate the navigation pane?
 

Navigation pane wont hide when form is loaded

Preview
Everytime my form loads the navigation pane is visible. I have unchecked the Display Navigation Pane in .

Access Options>Current Database>Navigation>

Closed and re-started Access and its still there! Anyone had the same issues and know how to fix it ? Is there a VBA fix ?
 

Hide Navigation Pane in Access 2010

Preview
In Access 2010, pressing F11 will either maximise / minimise the navigation pane.
Is there a method to hide it completly?

I use this to show / hide the toolbar:

If pubShowRibbonBar = False Then
DoCmd.ShowToolbar "Ribbon", acToolbarNo
Else
DoCmd.ShowToolbar "Ribbon", acToolbarYes
End If

pubShowRibbonBar is set when the user logs in.

I need somthing like this to completly hide the navigation pane
 

F11 shows navigation pane. What key hides it?

Preview
If the navigation pane is hidden by default (File, Options, Current Database, Navigation, Display Navigation Pane is selected) users can still access it by pressing the F11 key.
What key will hide it again?
 

Navigation Pane

Preview
I am trying to control the Navigation Pane to hide or minimise it. How is this done in VBA?

The only Navigation Pane Objects I can find are for Outlo