Can't display processing info|

[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

 

[Dan Artuso]

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.

 

[Dirk Goldgar]

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.

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.

 

[Svein Engebretsen]

Thanks,- DoEvents did the trick.

Svein