Compiling Access2010 - eliminating bars

I'm going to be compiling my Access2010 application and rolling it out to users.
When they open the application, the Login form will open.
I wish to eliminate all other bars - navigation, toolbars, etc.
But I would like it to be opened when I develop.
I know I can use a docmd for the toolbar, but how do I deal with the navigation and other items?
How do I get it to toggle on when I'm in development/design?
Any hints?
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:
Provide a shortcut for the users to open the app.

Append to the command line in the shortcut the switch:


That kills all design features.

GNOVAKAuthor Commented:
Thanks - works great - is there a way to eliminate the FILE tab exit ?
the user can exit from there and I really dont want anything  - can I eliminate the FILE tab completely?
Gustav BrockCIOCommented:
That I don't know but I don't think so.

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"Thanks - works great - is there a way to eliminate the FILE tab exit ?"
Yes - see XML below - an excerpt from one of my Ribbons

If you are working with the Ribbon, you will want to become intimately familiar with this site:
LOADS of sample dbs with 'how tos'

Ribbon Creator tool is indispensable.

<customUI onLoad="OnRibbonLoad" loadImage="LoadImages">
 <command idMso="Help" enabled="false"/>
 <command idMso="WindowClose" enabled="false"/>
 <command idMso="WindowRestore" enabled="false"/>
 <command idMso="WindowMinimize" enabled="false"/>
 <command idMso="ApplicationOptionsDialog" enabled="true"/>
<command idMso="FileExit" enabled="false"/>
<ribbon startFromScratch="true">
GNOVAKAuthor Commented:
Where/how do I place the XML in access?
I would need to do this before compiling every time?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
When you create a custom Ribbon, the XML for the Ribbon goes in a table called

When Access loads, if it sees that table, then it acts accordingly.

What I posted is just a snippet of an actual custom Ribbon - showing how you would eliminate the Exit from the File Tab (as well as other items).
Note than it's not possible to completely eliminate the File tab itself.

I hate to say it, but you will need to get up to speed on Ribbons - and Gunter's site is the place to do this.

Here is the location for all of the sample DBs on his site:


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
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 Access

From novice to tech pro — start learning today.