Run 2 Processes in Separate Threads

[matt_tapia]

I have a procedure that can sometimes run for about a minute before it successfully completes or errors out. However, during that minute, nothing like a form or a report can be clicked on or viewed while that procedure is still running.

I would like the procedure to run separately so that a user can still click on a form or something and when the procedure completes, a message box is displayed to the user.

I can't seem to find anything like threading or the like anywhere for MS Access / VBA. Can someone point me in the right direction?

 

[boblarson]

Access is a single thread application. It cannot do multiple threads - sorry.

 

[tkurland]

Check the DoEvents function, if your process is in a loop, you can put the it inside the loop and it will allow other things to be processed. Check out Access help

 

[boblarson]

Check the DoEvents function, if your process is in a loop, you can put the it inside the loop and it will allow other things to be processed. Check out Access help

Yeah, that might help. Thanks for the reminder about that. It doesn't make Access run in different threads but it does release the processor to do other things besides what it is currently tasked to do in your code.