Results 1 to 3 of 3
  1. #1
    Degs29 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2013
    Posts
    38

    VBA code to show hidden navigation pane in Access 2003


    I've disabled the navigation pane on start-up of my database. I've also created a custom login page that shows up at start-up. What I need is the code that will make the navigation pane reappear when the login page recognizes me as the user. The database already recognizes all users and their permission levels, I just need the code to make the navigation pane appear.

    Thanks.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,646
    You have to set focus to some object in the pane. Review https://www.accessforums.net/access/...ane-34272.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    DepricatedZero's Avatar
    DepricatedZero is offline Cthulhu Fhtagn!
    Windows 8 Access 2007
    Join Date
    Apr 2013
    Location
    Cincinnati
    Posts
    65
    You can start Access with the Navigation Pane open and disable launching the initial window by holding shift when you open the database.

    Anyone can do this.

    I would recommend publishing out to a locked DB like an ACCDE to prevent users from accessing the Nav Pane, VBA Code, and anything else. Keep the ACCDB for your own use and publish out updates to other users.

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

Similar Threads

  1. Replies: 6
    Last Post: 10-30-2013, 02:47 PM
  2. Disabling the navigation Pane in Access
    By A kinason in forum Security
    Replies: 7
    Last Post: 05-09-2013, 07:07 PM
  3. Replies: 2
    Last Post: 04-21-2013, 08:03 AM
  4. Access 10 navigation pane...
    By jimbofoxman in forum Access
    Replies: 3
    Last Post: 02-02-2012, 09:30 AM
  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