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.