Turning off Ribbons in Access 2007

[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?

 

[Jeanette Cunningham]

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

 

[Albert D. Kallal]

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

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

 

[Jeanette Cunningham]

Thanks Tony, has this always been possible in A2007?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Albert D. Kallal]

Thanks Tony, has this always been possible in A2007?

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.