Is there away to turn off the Navigation Pane so my user does not have access to it?
I used to be able to do something like that in 2003.
Is there away to turn off the Navigation Pane so my user does not have access to it?
I used to be able to do something like that in 2003.
Do you mean the left hand side Navigation pane in MSAccess 2007?
If so, yes there is. I'll see if I can dig up the code.
I "think" this is the code to turn off the Navigation Pane in 2007:
DoCmd.SelectObject acForm, , True
RunCommand acCmdWindowHide
You'd want to put this in your startup form's onLoad or OnOpen event.
PMFJI, but I'm having a similar problem with Access 2010. When I Import a data table -- Either from another Access MDB or a dBase file -- that *&@$#* Navigation pane pops out and gives my users something to look at that shouldn't be there!
I tried out this code on one of my apps that exhibits this behavior, with no change: the Navigation Pane still shows up after a table import.
Steve
I have not tried it yet in 2007 still having other problems.
When I put the code in my startup form and if it does go away.
How do I get it back if I need tot get access for some reason?
Open your database application FE
go to the Office button in upper left
select 'Access Options' button in bottom right
select 'Current Database' on left
....look down to 'Navigation' and uncheck the display
go to Amazon and buy a used Access textbook
hope this helps.
You can also bypass the auto-startup settings & display the usual navigation panels by holding down the left-hand "Shift" key on the keyboard while you start the program. This has worked in every version of Access I've used, including 2010.
Steve
You can switch the navigation pane on with F11 just like opening the database window - However a second F11 collapses but does not hide it.
I put the code into the OnActivate event so if it does pop up in odd places - (and it does!) then returning to the main form deals with it.
Note that for the Navigation pane, in MSAccess 2010, you can click File -> 'Edit Options', then 'Current Database' and then uncheck the Navigation bar checkbox.