Custom form with animation during time-consuming processing

[rdemyan via AccessMonster.com]

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

[Tom van Stiphout]

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.

[Gord]

>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