By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,918 Members | 1,816 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,918 IT Pros & Developers. It's quick & easy.

Custom form with animation during time-consuming processing

P: n/a
My application has a lot of complicated SQL statements, calculations,
processing that takes time. I've created a custom form to act like a
messagebox. It has 10 small rectangles on it that change color sequentially
to let the user know that processing is occurring. This 'animation' occurs
via the form timer event.

However, I'm having trouble getting the animation to occur for all types of
processing events. It appears that I have to add DoEvents to the complex
processing code so that Access takes the time to update the 'animation'
occuring on the custom message box.

If the code that is running has a loop that is causing most of the slow
processing, then adding DoEvents to the loop works quite well and the
animation proceeds nicely.

But if it doesn't or is spread out over a lot of different types of
processing, then DoEvents doesn't work so well.

How do I keep the animation on the custom form showing when the processor is
off running calculation intensive processes.

--
Message posted via http://www.accessmonster.com

Sep 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Thu, 14 Sep 2006 02:26:09 GMT, "rdemyan via AccessMonster.com"
<u6836@uwewrote:

You can't. Live with it.
You need a multithreaded environment to support this. Access isn't one
of them.

-Tom.
>My application has a lot of complicated SQL statements, calculations,
processing that takes time. I've created a custom form to act like a
messagebox. It has 10 small rectangles on it that change color sequentially
to let the user know that processing is occurring. This 'animation' occurs
via the form timer event.

However, I'm having trouble getting the animation to occur for all types of
processing events. It appears that I have to add DoEvents to the complex
processing code so that Access takes the time to update the 'animation'
occuring on the custom message box.

If the code that is running has a loop that is causing most of the slow
processing, then adding DoEvents to the loop works quite well and the
animation proceeds nicely.

But if it doesn't or is spread out over a lot of different types of
processing, then DoEvents doesn't work so well.

How do I keep the animation on the custom form showing when the processor is
off running calculation intensive processes.
Sep 14 '06 #2

P: n/a
>How do I keep the animation on the custom form showing when the
>processor is off running calculation intensive processes.
You could try using an AVI animation displayed by an Animation Control
on the form. I have used the freeware animation control from CCRP
(http://ccrp.mvps.org/) in the past with good success.
Gord
rdemyan via AccessMonster.com wrote:
My application has a lot of complicated SQL statements, calculations,
processing that takes time. I've created a custom form to act like a
messagebox. It has 10 small rectangles on it that change color sequentially
to let the user know that processing is occurring. This 'animation' occurs
via the form timer event.

However, I'm having trouble getting the animation to occur for all types of
processing events. It appears that I have to add DoEvents to the complex
processing code so that Access takes the time to update the 'animation'
occuring on the custom message box.

If the code that is running has a loop that is causing most of the slow
processing, then adding DoEvents to the loop works quite well and the
animation proceeds nicely.

But if it doesn't or is spread out over a lot of different types of
processing, then DoEvents doesn't work so well.

How do I keep the animation on the custom form showing when the processor is
off running calculation intensive processes.

--
Message posted via http://www.accessmonster.com
Sep 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.