Navigation Pane Help Please...

[Kristena]

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.

[alansidman]

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

[Kristena]

Alan, thank you so much for the help. I appreciate it.