Hide menu bar in ACCESS 2010

Posted on 2013-09-12
Medium Priority
Last Modified: 2013-09-12
OK, seems simple, but I have a database that when I am indevelopment mode, I want to see all the objects and menus, but when the user opens the database, I want the menus and objects to hide - this is an ACCESS 2010 database.

Question by:ssmith94015
LVL 53

Expert Comment

by:Gustav Brock
ID: 39487460
You could run it as a runtime with the /runtime parameter in a shortcut.

LVL 50

Accepted Solution

Dale Fye earned 2000 total points
ID: 39487487
I have code in the Open event of a splash form that checks to see if the userID is mine.  I use the fOsUserName() function found at: http://access.mvps.org/access/api/api0008.htm for that purpose.

If the userID is mine, then I close the form and display the ribbon and navigation pane

docmd.showtoolbar "Ribbon", acToolbarYes            'or actoolbarno

Otherwise, I use that line with the "acToolbarNo" argument.  You can hide the navigation pane using the Access Options menu (there is a checkbox).  But if you want to do it with code, I use:

docmd.SelectObject acTable,,true
docmd.RunCommand acCmdWindowHide

The first line will actually display the navigation pane, the 2nd hides it.
LVL 21
ID: 39487660
In the development/master copy of the  front end (.accdb or ,.mdb) I leave it unlocked. The end users should never see it. ALl the full ribbon/menus are available.

After compiling the front end .accde/.mde for deployment, I open it up and lock it down. Once the testing has been completed, this locked down version  is deployed to the users.

Author Closing Comment

ID: 39487756
this is exactly what I was looking for, thank you.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question