Access 2007

  • Thread starter Thread starter Frank
  • Start date Start date
F

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.
 
You mean you'd like to get the old menu instead of the ribbon? Sorry, you
can't.
 
I just want to "turn-off" or "hide" the thing (it's taking up too much screen
space) ... is that possible?
 
Frank said:
I just want to "turn-off" or "hide" the thing (it's taking up too much
screen
space) ... is that possible?
Click to expand...

Ctrl-F1 minimizes it. Or right-click on it, then Minimize.
 
Frank said:
No ... sorry ... I'm looking for code to do it ...
Click to expand...

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
 
Thank you ... I'll try these ...

Sky said:
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
Click to expand...
 
I tried to insert the ShowToolbar as a Macro Action for a form load and it
doesn't recognize Ribbon or even "Ribbon" name.
 
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
 
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.
 
Back
Top