Access 2007

[Frank]

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.

 

[Douglas J. Steele]

You mean you'd like to get the old menu instead of the ribbon? Sorry, you
can't.

 

[Frank]

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

 

[Sky]

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

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

 

[Frank]

No ... sorry ... I'm looking for code to do it ...

 

[Sky]

No ... sorry ... I'm looking for code to do it ...

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

 

[Frank]

Thank you ... I'll try these ...

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

 

[KarlH]

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

 

[Sky]

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

 

[KarlH]

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.