Results 1 to 10 of 10

Turn off Navigation Pane

  1. #1
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    Turn off Navigation Pane

    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.

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    643
    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.

  3. #3
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    643
    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.

  4. #4
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123

    Unfortuntaely, it doesn't

    Quote Originally Posted by pkstormy View Post
    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

  5. #5
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226
    I have not tried it yet in 2007 still having other problems.

  6. #6
    newtoAccess is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Nov 2009
    Posts
    226

    How to get access to left navigation pane

    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?

  7. #7
    NTC
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    1,480

    its an option

    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.
    www CahabaData com

  8. #8
    SteveF is offline Generally AccessAble
    Windows XP Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Location
    Fourth Corner
    Posts
    123

    Auto-Starup Bypass

    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

  9. #9
    ian@barnsoft.co.uk is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    1

    Navigation Pane Blues

    Quote Originally Posted by SteveF View Post
    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.

  10. #10
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    643
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Navigation Pane
    By Patrick.Grant01 in forum Programming
    Replies: 11
    Last Post: 01-08-2013, 02:55 PM
  2. Replies: 0
    Last Post: 07-26-2010, 12:45 PM
  3. Navigation Pane pain
    By Felmer Dingle in forum Access
    Replies: 0
    Last Post: 06-17-2010, 10:09 AM
  4. Navigation Pane Issue
    By mimi in forum Import/Export Data
    Replies: 0
    Last Post: 02-23-2010, 11:29 AM
  5. Control navigation pane
    By ohporter in forum Access
    Replies: 0
    Last Post: 05-27-2008, 11:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums