Event Execution

[PeterM]

I have a form that contains 3 charts on it. The form works fine except it
takes about 2-4 seconds for each of the charts to appear. The charts are
fairly complicated. All of the tables/queries have been analyzed and
optimized.

What I am looking for is the proper event that I can use that tells me that
all 3 charts have been populated/displayed. I want to display a field that
says "One Moment Please" until the 3 charts have been displayed. I've tried
the AfterRender, AfterFinalRender, AfterLayout events but none of them fire.

Is there an event that I can use to determine that the charts have been
displayed.

Thanks again!

 

[Arvin Meyer [MVP]]

Try using this form for Please Wait ...

http://accessmvp.com/Arvin/PleaseWait2K.zip

 

[PeterM]

Arvin... I appreciate the reply, but I know how to use the timer event. It
doesn't solve my problem because I never know how long it will take to
display the charts. I need an event or some way to detect that the form is
complete and that the display of the charts is complete, If I can determine
that, I can then close the "One Moment Please" form.

Is there anything else I can try.

 

[Arvin Meyer [MVP]]

VBA is a sequential language. Unless you try to make things occur out of
sequence, everything should work OK. That said, you can try certain things.

1. Add a DoEvents to you code which relinquishes control to the OS to
finish a process
2. Add a control to the form that gets a value from the chart, once that
value = what you want it to, close the "Please Wait" form.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access