DataBase - Access 2007

Asked By PremierSoftwar

27-Feb-09 04:05 AM

Hello!

Can anyone help me please ... how do I turn off Access 2007's ribbon when I
open an Access 2000 dB application?

Thanks in anticipation.

01-Mar-09 11:04 AM

You mean you would  like to get the old menu instead of the ribbon? Sorry, you
cannot.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

01-Mar-09 05:58 PM

I just want to "turn-off" or "hide" the thing (it is taking up too much screen
space) ... is that possible?

01-Mar-09 08:41 PM

Ctrl-F1 minimizes it. Or right-click on it, then Minimize.

01-Mar-09 09:08 PM

No ... sorry ... I am looking for code to do it ...

01-Mar-09 09:19 PM

DoCmd.ShowToolbar "Ribbon", acToolbarNo completely hides the ribbon.

But if this is for a custom application, you probably want some kind of
menus and/or toolbars. Of course, you can specify toolbars, ribbons, and
menus in your form and report properties.

You can also make Access run with your custom Access 2003-style menus and
toolbars and no ribbon, by setting the startup properties: File (Alt-F),
Access Options, Current Database, Ribbon and Toolbar Options, then turn off
Allow Full Menus and Allow Built-in Toolbars. You can set these options
programmatically the same as Access 2003 (AllowFullMenus and
AllowBuiltInToolbars), but this does not take effect until you reopen the
database.

- Steve

03-Mar-09 10:03 AM

Thank you ... I will try these ...

12-Mar-09 12:21 PM

I tried to insert the ShowToolbar as a Macro Action for a form load and it
does not recognize Ribbon or even "Ribbon" name.

12-Mar-09 12:49 PM

I don't know anything about Macro Actions. The following VBA code works for
me, as I originally posted:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

You might use VBA rather than macros, for many reasons.

- Steve

16-Mar-09 08:37 AM

Yup!  It worked as you said.  Rather than using a RunCommand, ShowToolbar,
Ribbon, in a Macro Action (it didn't recognize Ribbon as a toolbar), I
created a Function, named it HideRibbon(), used your code, then called it
with a RunCode, HideRibbon() in my Macro Action.  Thanks for your help.