MS Access 2007--Hide ribbon but not the Quick Access Toolbar

I'm trying to hide the ribbon on my database without hiding the Quick Access Toolbar and the Office Button.  So far I've tried the following.

1. I deselected the Allow Full Menus option under the Ribbon and Toolbar Options.  This hides all tabs except the Home menu, which I would also like to hide, and leaves the QAT and Office Button visible.

2. I added "DoCmd.ShowToolbar "Ribbon", acToolbarNo" to the On Load event of my form.  This however hides everything (Ribbon, QAT, and Office Button).

Any suggestions are appreciated.
Who is Participating?
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
FYI, this site:

 is one of the better ones around covering all topics dealing with the ribbon.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 You'll have to do a custom (blank) ribbon.  The quick access toolbar is part of the ribbion.

 Check out the following MSKB article:

  Customize the Ribbon

giswestAuthor Commented:

Thank you for providing me with the direction I need to resolve this issue. The resources you provided will be most helpful.

Thanks again.
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.

All Courses

From novice to tech pro — start learning today.