[AccessD] Chart Loading Delay...WAS..(no subject) SOLVED

Hello All,

The issue was I did not understand why if I used docmd.openform("myform")...and then a bunch of other code...and myform had a chart on it...if I stepped through the code...the chart would never load...no matter if I put a loop or some delay...it would not load.  If I ran the code withOUT stepping through the charts would not finish loading until all the rest of the code finished executing...

I am still curious as to why this occurs...

But here is my solution:  doevents in side of a timer loop.

Thanks,

Mark A. Matte

DoCmd.OpenForm "frmGraphs"
Dim MyTimer
MyTimer = Now()
   Do While Now() < DateAdd("s", 5, MyTimer)
     DoEvents
   Loop


> From: markamatte at hotmail.com
> To: accessd at databaseadvisors.com
> Date: Wed, 22 Oct 2008 14:11:55 +0000
> Subject: Re: [AccessD] Chart Loading Delay...WAS..(no subject)
>
>
> The DoEvents approach I KINDA understand...but why would opening it hidden have an effect?
>
> Thanks,
>
> Mark A. Matte
>
>
>> Date: Tue, 21 Oct 2008 14:46:36 -0700
>> From: davidmcafee at gmail.com
>> To: accessd at databaseadvisors.com
>> Subject: Re: [AccessD] Chart Loading Delay...WAS..(no subject)
>>
>> I think a combination of opening it hidden and using DoEvents as suggested
>> would take care of the problem.
>>
>> On Tue, Oct 21, 2008 at 12:44 PM, Mark A Matte wrote:
>>
>>>
>>> It doesn't matter where I put it in the code...if I step through the
>>> code...the charts never populate. If I let the code run as is...the
>>> charts(even though the open form was the first thing) won't populate until
>>> everything else is done.
>>>
>>> My issue is not how it looks...I need the charts populated before the rest
>>> of my code fires. Will hiding it do this?
>>>
>>> Thanks,
>>>
>>> Mark A. Matte
>>>
>>>
>>>> Date: Tue, 21 Oct 2008 12:05:53 -0700
>>>> From: davidmcafee at gmail.com
>>>> To: accessd at databaseadvisors.com
>>>> Subject: Re: [AccessD] (no subject)
>>>>
>>>> Can you open the form hidden a step or two before then make it visible
>>> after
>>>> you populate the charts?
>>>>
>>>> On Tue, Oct 21, 2008 at 7:38 AM, Mark A Matte wrote:
>>>>
>>>>>
>>>>>
>>>>> Hello All,
>>>>>
>>>>> Sorry for the re-post...but I didn't see any responses...
>>>>>
>>>>> I have a form with a number of graphs. I am exporting them to
>>> Powerpoint.
>>>>> When I open this form via code using DoCmd.OpenForm "frmGraphs" ...the
>>>>> graphs do not load right away. If I step through the code...they never
>>> load
>>>>> any data??? I can get around this by opening the form prior to my
>>> starting
>>>>> the export...but I thought I should be able to run this whole thing with
>>> one
>>>>> click???
>>>>>
>>>>> Can I docmd.open...then wait? Any Thoughts?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Mark A. Matte
>>>>> _________________________________________________________________
>>>>> Want to read Hotmail messages in Outlook? The Wordsmiths show you how.
>>>>>
>>>>>
>>> http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns!20EE04FBC541789!167.entry?ocid=TXT_TAGLM_WL_hotmail_092008
>>>>> --
>>>>> 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
>>>
>>> _________________________________________________________________
>>> Want to read Hotmail messages in Outlook? The Wordsmiths show you how.
>>>
>>> http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns!20EE04FBC541789!167.entry?ocid=TXT_TAGLM_WL_hotmail_092008
>>> --
>>> 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
>
> _________________________________________________________________
> Stay organized with simple drag and drop from Windows Live Hotmail.
> http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_102008
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
When your life is on the go—take your life with you.
http://clk.atdmt.com/MRT/go/115298558/direct/01/