David McAfee
davidmcafee at gmail.com
Wed Oct 22 11:28:19 CDT 2008
It doesn't, it only hides it while things are happening so it doesnt look like a blank form has opened up. Without actually looking at the code, I don't know what was happening. On Wed, Oct 22, 2008 at 7:11 AM, Mark A Matte <markamatte at hotmail.com>wrote: > > 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<http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns%2120EE04FBC541789%21167.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<http://windowslive.com/connect/post/wedowindowslive.spaces.live.com-Blog-cns%2120EE04FBC541789%21167.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 >