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?

[RuralGuy]

Access is single threaded so sorry but only one process at a time. If you can break down the process into chunks then maybe you could keep a progress meter updated.