Restoring forms

I create alot of vb projects that processes data to SQL7 , Excel, and Access. When processing the data I usually have a progress bar running or use Label captions to keep track of what has been processed. The problem is that when the .exe is running and I
minimize the form to the systray I can never RESTORE the form
to Desktop until the code has completed. I would like to check
the status of the processing periodically. I have not used API yet but it seems API programming is the only answer. Don't I have to capture the handle somehow in order to RESTORE the
form?? Any code avaliable to show me the way???

Thanks in Advance

TJJ

So your App freezes? Try adding the DoEvents statement in your loop.

I forgot all about the DoEvents function. Put it in several places and it cured some of the problem. However, I use the command object that has to go thru a couple million records. Anyway to restore the form to the desktop when then cmd.execute is
is doing it's thing??

Try placing your showing code at the beginning of your sub routine.

E.g:

VB Code:

MyForm.show
'<--cother code here