Mark A Matte
markamatte at hotmail.com
Wed Oct 22 09:11:55 CDT 2008
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