"Blinking" message on form

J

JimP

How can I make a message blink on a form (e.g. "Processing"), while some
queries are running in the background?
 
T

Tom van Stiphout

On Fri, 26 Jun 2009 08:20:34 -0500, "JimP" <[email protected]>
wrote:

It may be better to use the Progress Bar. See SysCmd in the help file.
When people moved from DOS to Windows one thing they were happy to
leave behind was the blinking characters :)

-Tom.
Microsoft Access MVP
 
J

JimP

I have no idea how long the query will run, so I'm not sure how to update
the status of the progress meter.
 
T

Tom van Stiphout

I thought with "some queries" you meant that you were running multiple
queries in a row. So you can advance each query 100/Count percent.

DoCmd.OpenQuery is another interesting option, because it
automatically shows a progress bar.

-Tom.
Microsoft Access MVP
 
Top