[AccessD] A2007 Properties during runtime

David McAfee davidmcafee at gmail.com
Tue Dec 29 15:31:51 CST 2009


I used to love to be able to view and adjust listbox columns with the
properties at runtime.
I guess I wont be able to now that I've switched back to A2007. :(

D

On Tue, Dec 29, 2009 at 1:23 PM, Heenan, Lambert
<Lambert.Heenan at chartisinsurance.com> wrote:
> Ah... 2007... Not there yet.
>
> It sounds like good old M$ has 'fixed' a problem with Access 2002/2003, where the properties sheet would be visible when not wanted and you had to remember to set the objects 'Allow Design Changed' property to "Design View Only" before releasing an app. to the wild (the pointless default being "All Views").
>
> And they 'fixed' it so well you have lost functionality. Looks like you will have to roll your own solution: say a pop-up form that displays the information you want, or a bunch of Debug.Print statements.
>
> Lambert ;-(
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
> Sent: Tuesday, December 29, 2009 4:07 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2007 Properties during runtime
>
> Im just talking about displaying them on my new box when troubleshooting a combo/list box.
>
> In prior versions, you could display the properties for a control in design view then when you switch to form view it would still be visible, not so in A2007.
>
> DoCmd.RunCommand acCmdProperties gives an error in A2007:
>
> Runtime error '2046'
> The command or action 'Properties' isn't available now.
>
> :/
>
>
>
> On Tue, Dec 29, 2009 at 12:27 PM, Heenan, Lambert <Lambert.Heenan at chartisinsurance.com> wrote:
>> If you mean showing the properties sheet *AT* runtime, in a full MS Access installation then all you need is...
>>
>>    Combo3.SetFocus
>>    DoCmd.RunCommand acCmdProperties
>>
>> But if you are talking about displaying the properties sheet while running an application in the runtime environment (i.e. MS Access not installed) then I don't know how to do that.
>>
>> Lambert
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
>> McAfee
>> Sent: Tuesday, December 29, 2009 1:50 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] A2007 Properties during runtime
>>
>> Does anyone know how to enable properties during runtime?
>>
>> If was trying to troubleshoot a cascading combobox rowsource to see if it is reading correctly.
>>
>> I know I can check if many different ways, but I like to enable properties and look at the data tab's rowsource field as I am clicking on things.
>>
>> It seems I can't display the combo box properties in runtime.
>>
>> Does anybody know how?
>>
>> David




More information about the AccessD mailing list