Topics Search

Hide Navigation Pane in Access 2010

Hide Navigation Pane in Access 2010
Views: 236
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
Sponsored Links:

More topics

 

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?
 

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?
 

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 ?
 

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.
 

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?
 

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
 

Access 2010: How to keep Nav Pane hidden

Preview
people,
Q. In Access 2010, how do you stop a hidden Navigation Pane from being unhidden?

These things I know:
- In MS Access you can hide the Navigation Pane to prevent users from getting to the form objects etc.
- This setting can be bypassed by holding SHIFT while opening the database.
- There is code that can disable the bypass key (the SHIFT key).

In MS Access 2007 this works fine. You can't get to the Options to turn the Nav Pane back on.

But now comes my problem: In Access 2010, the File menu is still visible, which has the 'Privacy Options' available. This lets the user go in and switch the Nav Pane back on again.

How do I stop this in Access 2010? I either need to remove the File menu, or remove the Privacy Options item from it
 

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
 

Hide 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. We'll go through the options from the easily method to the most difficult.