Darryl Collins
Darryl.Collins at coles.com.au
Sun Feb 8 17:22:54 CST 2009
Thanks Maxx, Australia day was nice, but this weekend has been awful in the part of Oz I live (South East Australia). Massive bushfires with many houses destroyed and lives lost - whole towns have been wiped off the map. Crazy hot weather (47 degs C - 116.6F) with wild wild 90 km/ph winds. Insane stuff. Worst firestorm and weather since records began. regards Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Max Wanadoo Sent: Saturday, 7 February 2009 4:14 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] OT: Aussie Day Aussie Day coming up. Good on yer boys - have a great one. Wish I could post a pps file on this site. I have a great one which the Oz would love. Maxx -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: 05 February 2009 15:38 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2007 - Programmatically Minimize Ribbon << Why would the ribbon be exempted from programmatic manipulation. Why no Application.Ribbon. Or a DoCmd.Ribbon?>> That's because despite any overtures made, Microsoft does not consider Access to be a professional development tool; user features first and foremost always. Development features are always secondary. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Thursday, February 05, 2009 10:21 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] A2007 - Programmatically Minimize Ribbon Agree. In A2003 I never saw anything that could be done through the toolbars or otherwise, that could not be done in VBA using one or another object model. This seems to be a real basic difference in 2007. Why would the ribbon be exempted from programmatic manipulation. Why no Application.Ribbon. Or a DoCmd.Ribbon? Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Thursday, February 05, 2009 6:55 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2007 - Programmatically Minimize Ribbon All of this to get rid of something that should be directly programmatically manipulatable. John W. Colby www.ColbyConsulting.com William Hindman wrote: > "SendKeys"????????? > > ...shakes head ...returns to A2K3 :( > > ...sorry Stu, just couldn't help myself :) > > William > > -------------------------------------------------- > From: "Stuart McLachlan" <stuart at lexacorp.com.pg> > Sent: Wednesday, February 04, 2009 10:14 PM > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Subject: Re: [AccessD] A2007 - Programmatically Minimize Ribbon > >> Rocky! >> >> This was answered two months ago when you asked about "turning off >> the ribbons programmatically" >> >> Here's what I posted then: >> My Height was slightly different to those in the link, probably >> because of different screen resolutions, fonts etc but it looks like >> it will always be above/below 100 so this should work anywhere. It >> certainly works for me: >> >> Function RibbonMinimized() As Boolean RibbonMinimized = >> Application.CommandBars("Ribbon").Height < 100 End Function >> >> The following four functions give you full control over the Ribbon >> :-) >> >> Function HideRibbon() >> DoCmd.ShowToolbar "Ribbon", acToolbarNo End Function >> >> Function ShowRibbon() >> DoCmd.ShowToolbar "Ribbon", acToolbarYes End Function >> >> Function MinimizeRibbon() >> If Not RibbonMinimized Then SendKeys "^{F1}" >> End If >> End Function >> >> Function MaximizeRibbon() >> If RibbonMinimized Then SendKeys "^{F1}" >> End If >> End Function >> >> >> -- >> 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 -- 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 -- 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.