Results 1 to 7 of 7
  1. #1
    Dunro is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39

    Hide navigation pane in Access 2010 hiding form instead

    Hi everyone,



    We're upgrading to Access 2010, and one of my databases (split FE which utilizes instanced forms) is having issues. I traced it down to the function (in a module) that hides the navigation pane.

    Code:
    DoCmd.NavigateTo "acNavigationCategoryObjectType"        'Select Navigation Pane
    DoCmd.RunCommand acCmdWindowHide    'Hide selected
    In Access 2007, this works fine. In Access 2010, this hides the current window instead of the navigation pane.

    Any ideas what I'm doing wrong?

    Thank you!

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    I had the same problem. The navigation pane was killing me. So I started using this..

    Code:
    Application.CommandBars.DisableAskAQuestionDropdown = True
    DoCmd.Maximize
    
    
    Application.CommandBars.DisableCustomize = True
    This hides the navigation pane ALMOST all the time. To combat the rare occasion when it still opens I marked all the tables, queries, forms,modules etc etc as hidden. Right click them and go to properties to do this. Also make sure to use a custom menu, so the default does not load.

  3. #3
    Dunro is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39
    Haven't found a fix, but here's my workaround to prevent forms from being inadvertantly hidden if the NavigateTo doesn't "take."

    Code:
    DoCmd.NavigateTo "acNavigationCategoryObjectType"        'Try to select Navigation Pane
    If Len(Application.CurrentObjectName) = 0 Then
    ' make sure it hasn't selected something else... like a form. ' This still could hide the wrong thing, but I don't want to resort to an API call to verify. DoCmd.RunCommand acCmdWindowHide 'Hide selected.
    Else
    Debug.Print "Hide navigation bar tried to hide " & Application.CurrentObjectName & " at " & Now
    End If

  4. #4
    Dunro is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39
    Quote Originally Posted by redbull View Post
    I had the same problem. The navigation pane was killing me. So I started using this..
    Unfortunately, that code also results in the form being maximized.

  5. #5
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Just drop the docmd.maximize

  6. #6
    Dunro is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2011
    Location
    Toronto, Canada
    Posts
    39
    Nope, doesn't hide the navigation pane in my case.

  7. #7
    Dal Jeanis is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Not to resurrect this thread, but here's a thread with the module to fix this issue under all circumstances I've been able to test so far - https://www.accessforums.net/forms/h...orm-35876.html

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

Similar Threads

  1. Access 10 navigation pane...
    By jimbofoxman in forum Access
    Replies: 3
    Last Post: 02-02-2012, 09:30 AM
  2. Replies: 3
    Last Post: 01-12-2012, 02:04 PM
  3. Hiding Navigation Pane kills macro
    By SemiAuto40 in forum Programming
    Replies: 3
    Last Post: 12-09-2011, 02:05 PM
  4. Replies: 3
    Last Post: 11-15-2011, 06:29 PM
  5. Banish the Access 2010 Navigation Pane
    By SteveF in forum Access
    Replies: 3
    Last Post: 12-07-2010, 10:44 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
  •  
Other Forums: Microsoft Office Forums