Results 1 to 3 of 3
  1. #1
    Kristena is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2012
    Posts
    5

    Smile Navigation Pane Help Please...

    I have create a new database that I am almost ready to implement with our organization. There is a database we currently use that was created by someone else that when you open the database the Navigation pane and Ribbon bar (other than the "Home" tab) are not showing. When you click the Office button , The only options available are Close database, Recent Documents, and Exit Access. I would like to be able to do the same thing with my database for all user except the Admin (which would be me). Does anyone know how to do that. I do not know VBA at all. I know how to set up a Macro. I am figuring there might be an if then statement I can use to where if any form beside the admin form is chosen everything will be hidden.



    Any help will truly be appreciated.
    Last edited by Kristena; 01-13-2012 at 03:04 PM. Reason: My question was answered

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Open your database and click on the office button. Click on Options, click on current database. Uncheck the Display Navigation Pane checkbox. Uncheck in the Ribbons and Menus section the two check boxes. Save the changes. Close and reopen the database. It should be as you desire.

    If you wish to open the data base with full rights, hold down the shift key and press the enter button when attempt to open the database. This will by pass the instructions you just gave access in the first paragraph.

    Alan

  3. #3
    Kristena is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2012
    Posts
    5
    Alan, thank you so much for the help. I appreciate it.

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, 04:55 PM
  2. navigation pane 2007
    By stevepcne in forum Access
    Replies: 3
    Last Post: 11-17-2011, 05:51 PM
  3. Turn off Navigation Pane
    By newtoAccess in forum Access
    Replies: 9
    Last Post: 08-01-2011, 11:32 AM
  4. Navigation Pane pain
    By Felmer Dingle in forum Access
    Replies: 0
    Last Post: 06-17-2010, 11:09 AM
  5. Navigation Pane Issue
    By mimi in forum Import/Export Data
    Replies: 0
    Last Post: 02-23-2010, 01:29 PM

Tags for this Thread

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