Turning off Ribbons in Access 2007

  • Thread starter Thread starter Pete_E
  • Start date Start date
P

Pete_E

I recently moved a rather large application from Access 2003 to Access 2007.
I have user specific custom menus and toolbars in the database and need to
shut off the 2007 ribbons as they are not needed. Is there an efficient way
to do this through a startup macro or short snippit of startup code?
 
Assuming you have converted the db to A2007, as far as I know, you must have
at least one ribbon.
You could build a custom ribbon with only one group/button on it, and show
that, and also minimize it so that it doesn't take up much space.
I am assuming that there is code to minimize the ribbon - as I have never
needed to do this in code.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Pete_E said:
I recently moved a rather large application from Access 2003 to Access
2007.
I have user specific custom menus and toolbars in the database and need to
shut off the 2007 ribbons as they are not needed. Is there an efficient
way
to do this through a startup macro or short snippit of startup code?
--
Click to expand...

The following will hide the office button,t he QAT, and also hide the
ribbon.....

DoCmd.ShowToolbar "Ribbon", acToolbarNo

If you leave your app in 2003 format, then your startup code and custom
menus should show, and the ribbon should no display anyway.

Just make sure you un-check in startup the allow built in tool bars.

This is outlined here:

http://www.accessribbon.de/en/index.php?FAQ:7

so, you have several approaches here that should work...
 
Thanks Tony, has this always been possible in A2007?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Thanks Tony, has this always been possible in A2007?
Click to expand...

You mean:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

Yes, it is a one line command that hides all of the ribbon, the office
buttion and even the QAT.
 
Back
Top