Problem with long procedure

[ttlai]

Hello,

I have a procedure that imports a file into a DB and it could take up to 30 seconds to complete the procedure.

When the user executes this procedure, moves to another program that is open, then come back to the VB program, the VB program doesn't respond (freezes) until the procedure is over.

How do I get the form to not "freeze"?

Thanks in advance.

ttlai

[Cander]

try placing DoEvents in the loop if you have a loop coded. otherwise, put doevents right before the function call you are doing that is taking so long.

[ae_jester]

You need to add doevents within the procedure, which executes all events before continuing, such as mouse moves, form activate events etc.

[ttlai]

thanks, that was quick.

[Megatron]

Here's a link to some code that supposed to act like "DoEvents" but twice as fast.