471,086 Members | 954 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,086 software developers and data experts.

Custom form with animation during time-consuming processing

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
2 5583
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
>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.

Similar topics

1 post views Thread by Martijn Mulder | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.