Can't display processing info|

  • Thread starter Thread starter Svein Engebretsen
  • Start date Start date
S

Svein Engebretsen

I am performing a batch job, dumping field information from one table to
antoher. I want to display information about the process in a form.

On the form I have a button which starts the process. The process-code is
within the click-event of the button. For every record I set a text control
to "record x av y", but it doesen't show before the last record I am
processing.

Any suggestions why?

Svein
 
Hi,
If you mean you are looping through records, it's probably happening
way too fast to display. If that's not it, then post your code.
 
Dan Artuso said:
Hi,
If you mean you are looping through records, it's probably happening
way too fast to display. If that's not it, then post your code.
Click to expand...

Further, it's quite likely that the form is not repainted until your
loop is complete. You can probably fix this by inserting a

DoEvents

statement in your loop, at the cost of slowing down the whole process.
Unless each record takes a long time to process, I'd suggest you only
update the status box every n records, where n is 100, or 1000, or some
suitable number.
 
Back
Top