[AccessD] A2007 Properties during runtime

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