[AccessD] Turn off the ribbons programmatically

Well, that works for me:

IF SysCmd(acSysCmdAccessVer) = 12 THEN DoCmd.ShowToolbar "Ribbon",
acToolbarNo

I also put a command button on a test form to turn it back on.



On Wed, Dec 3, 2008 at 2:17 PM, Darryl Collins
<Darryl.Collins at coles.com.au>wrote:

>
> " I tried to record it in Excel 2007, but it didn't capture anything"
>
> That is because MS broke large parts of the Macro recorder's functionality.
>  Recording Charts for example is now completely buggered.
>
> cheers
> Darryl.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
> Sent: Thursday, 4 December 2008 4:05 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Turn off the ribbons programmatically
>
>
> Rocky, there's a simple keyboard shortcut that hides the ribbon -- just
> double-click the active tab. To unhide the ribbon, double-click the active
> tab again. But, I don't know how to do this programmatically. I tried to
> record it in Excel 2007, but it didn't capture anything.
>
> Susan H.
> >
> > Dear List:
> >
> > Is there a way to turn off the A2007 ribbons programmatically?  In a way
> > that will not cause the program to barf if it's being run by A2003?
> >
> > I have a legacy 2003 app that's run by the client on 2007.  The ribbon
> > takes
> > up so much freakin' real estate that you can't see the whole form on the
> > display.  Especially the exit button at the bottom which is kind of
> > important.
> >
> > I got the navigation pane to turn off: DoCmd.RunCommand acCmdWindowHide,
> > but
> > not the ribbon.
> >
> > MTIA
> >
> > Rocky
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> This email and any attachments may contain privileged and confidential
> information
> and are intended for the named addressee only. If you have received this
> e-mail in
> error, please notify the sender and delete this e-mail immediately. Any
> confidentiality, privilege or copyright is not waived or lost because this
> e-mail
> has been sent to you in error. It is your responsibility to check this
> e-mail and
> any attachments for viruses.  No warranty is made that this material is
> free from
> computer virus or any other defect or error.  Any loss/damage incurred by
> using this
> material is not the sender's responsibility.  The sender's entire liability
> will be
> limited to resupplying the material.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>