DataBase - Turning off Ribbons in Access 2007

Asked By Pete_E

20-Nov-09 10:31 AM

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

20-Nov-09 08:06 PM

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 does not 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

20-Nov-09 10:39 PM

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


--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

21-Nov-09 01:50 AM

Thanks Tony, has this always been possible in A2007?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

23-Nov-09 04:17 AM

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.


--
Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com