locked
Don't Display Navigation Pane RRS feed

  • Question

  • Upon entry into my Access 2007 Front End (.accde,) most users have the navigation pane disabled by default. Certain vba actions (e.g. "transferspreadsheet") cause the Navigation pane to reappear. How can I not just minimize it, but close it after such an event?

    Jim

    Wednesday, November 20, 2013 6:48 PM

Answers

  • Jim

    After each line of code that exposes the Pane put this (or maybe create a function to use as a wrapper)

      ' Move focus to the navigation pane/database container
      DoCmd.SelectObject acTable, "", True
      
      ' Use the window menu to hide or show the database window/navigation pane
      DoCmd.RunCommand acCmdWindowHide


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, November 20, 2013 9:13 PM

All replies

  • Jim

    After each line of code that exposes the Pane put this (or maybe create a function to use as a wrapper)

      ' Move focus to the navigation pane/database container
      DoCmd.SelectObject acTable, "", True
      
      ' Use the window menu to hide or show the database window/navigation pane
      DoCmd.RunCommand acCmdWindowHide


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, November 20, 2013 9:13 PM
  • Although I believe Bill's answer will minimize the Navigation pane, it will not remove it. The user can still reopen it.

    Jim

    Wednesday, November 27, 2013 4:11 PM
  • Although I believe Bill's answer will minimize the Navigation pane, it will not remove it. The user can still reopen it.

    Jim

    Jim

    You are mistaken. My code hides the Nav Pane, not just collapse it. As long as you do not allow Special Keys, the user has no way to expose it again.

    And the code works in 97, 2000, 2002, 2003 as well.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Wednesday, November 27, 2013 8:55 PM
  • I will implement it optimistically! Thanks

    Jim

    Thursday, November 28, 2013 3:52 AM
  • You're welcome.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, December 3, 2013 4:35 PM