[AccessD] A2007 Properties during runtime

I do like the layout view in reports.
Adjusting controls the only thing I like better in Crystal over Access
reports, and now Access has that ability. :)

Thanks for the tip.

David

On Tue, Dec 29, 2009 at 2:18 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:
> Yes, seems layout view is missing in adp - too bad...
> Asger
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af David McAfee
> Sendt: 29. december 2009 22:58
> Til: Access Developers discussion and problem solving
> Emne: Re: [AccessD] A2007 Properties during runtime
>
> I don't see that option from the ribbon drop down or when right
> clicking  the form name from the navigation pane.
>
> Only Design View and Form View are shown.
>
> hmm, just tried it in an mdb and it works fine.
>
> Wonder if the issue is that this is an ADP?
>
> David
>
>
> On Tue, Dec 29, 2009 at 1:47 PM, Asger Blond <ab-mi at post3.tele.dk> wrote:
>>
>> David,
>> Access 2007 now has 3 view modes for forms: design, form, and layout view. To see the properties window during runtime use layout view.
>> HTH
>> Asger
>>
>> -----Oprindelig meddelelse-----
>> Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af David McAfee
>> Sendt: 29. december 2009 22:32
>> Til: Access Developers discussion and problem solving
>> Emne: Re: [AccessD] A2007 Properties during runtime
>>
>> 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