Status Form Problem

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Access 97 - WINNT
I have a status form that updates with a message when each query in a
routine finishes. The routine takes in excess of 17 minutes to complete. On
the machine that I used to develop the routine, it updates properly and I
can tell when each query finishes. On the users' machine, the form fails to
update it's display until after all queries are finished. The routine runs
OK, just no visual updates during it's run. I experienced the same problem
on the development machine but the problem went away when I deleted the
status form and rebuilt it from scratch. I have also seem this happen during
other routines when I just want to have a label appear in the middle of a
run of queries.
Anyone know what causes this or how to prevent it?
 
I have seen cases similar to this and in some cases, I found slower PCs
didn't have enough processing power to update the screen when another query
processing was started.

Try to put in a few DoEvents to allow Windows time to refresh the screen.
 
Thanks .. I suspected that there must be somthing like this available but
until now didn't know about doEvents.
 
Back
Top