Hide menu bar in ACCESS 2010

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.

Sandra SmithRetiredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gustav BrockCIOCommented:
You could run it as a runtime with the /runtime parameter in a shortcut.

Dale FyeCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.
Sandra SmithRetiredAuthor Commented:
this is exactly what I was looking for, thank you.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.