Hide Navigation Pane in Access 2010
Is there a method to hide it completly?
I use this to show / hide the toolbar:
If pubShowRibbonBar = False Then
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.ShowToolbar "Ribbon", acToolbarYes
pubShowRibbonBar is set when the user logs in.
I need somthing like this to completly hide the navigation pane
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I was hoping for
Application.SetOption "Hide Navigation Pane", true/false
But Access doesn't like this. What is the code I should use?
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 ?
What key will hide it again?
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
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
The only Navigation Pane Objects I can find are for Outlo
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.