[AccessD] A2012 Ribbon collapse (not hide) from code

Stuart McLachlan stuart at lexacorp.com.pg
Fri Feb 8 08:36:12 CST 2013


The other interesting snippet is in Access 2010 VBA Help:

CommandBars.ExecuteMso Method 
"  Note 
The Microsoft Office Assistant has been deprecated in the 2007 release of the Microsoft 
Office system 
 
And yet they introduced  this ExexuteMSO parameter in Access 2010.  WTF?

-- 
Stuart

On 8 Feb 2013 at 13:39, Gustav Brock wrote:

> Hi Stuart
> 
> Thanks. So did I. Searched for minimize instead of collapse and found by
> Albert D. Kallal:
> 
> http://social.msdn.microsoft.com/Forums/en-US/accessdev/thread/f8e6397f-fb63
> -4508-a64c-5119303dce31
> 
> Now, the big question is how to maximize it when minimized??
> This is where the intuitive part comes in. I tried, of course, with all the
> obvious variations - then returned to the thread and browsed to the bottom:
> 
> <quote>
> If I use the same line of code to hide the ribbon in the OnClose property,
> the ribbon is restored.  Not completely intuitive, I think, that minimizing
> something that's minimized results in something maximized.
> </quote>
> 
> You gotta love that kind of logic.
> Time for Friday beer and weekend.
> 
> /gustav
> 
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
> Sendt: 8. februar 2013 13:06
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] A2012 Ribbon collapse (not hide) from code
> 
> Just discovered, Access 2010:
> 
> CommandBars.ExecuteMso "MinimizeRibbon"
> 
> --
> Stuart
> 
> On 8 Feb 2013 at 22:00, Stuart McLachlan wrote:
> 
> > 2007/10   I'm guessing it will work in 2012:
> > 
> > A real kludge, but I've never found an alternative. 
> > 
> > If CommandBars("ribbon").Height > 100 Then SendKeys "^{F1}", True End 
> > If
> > 
> > --
> > Stuart
> > 
> > On 8 Feb 2013 at 11:51, Gustav Brock wrote:
> > 
> > > Hi all
> > > 
> > > Is this possible? It's easy to _hide_ , but how to collapse (or
> minimize)?
> > > Also, client is not interested in custom ribbons; the default is fine. 
> > > 
> > > /gustav
> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list