[AccessD] Turn off the ribbons programmatically

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