Question Access 2010: How to keep Nav Pane hidden

This is an undocumented tip I found:
(Add once at start up and add this after every attach / link to external tables)
' hide the navigvation bar
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
-------
The above works because it points directly to the navigation pane. Just using docmd.runcommand acwindowhide may be unpredictible because it depends on what had the previous focus:
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

ewc you're a genius!
 
in addition to the above code which hide the navigation pane, user can still make it visible by pressing the F11 key. after issueing the 2 above code, you can disable F11 through Autokeys macro. create a macro, create a submacro and name it F11. put Beep as its action. save the macro and name it Autokeys. done.
 

Users who are viewing this thread

Back
Top Bottom