VBA + Threads

Question

How can I create a process running on a separate thread in MS Access VBA? I would like to create a process that will just sit and wait for a message.

Answer 1

Here is a good article that describes COM Threading

Answer 2

Good question, but i think it can't be done.

Answer 3

The quickest way I can think of is to create a Form and put an existing or do-it-yourself control on it.

Answer 4

There is no way to do this directly in VBA itself. Here is a MSDN forum discussion talking about this in detail. Office never exposed any of the VBA extensions for multithreading.

However, you can do this by calling out to the Windows API, or creating your own COM object in VBA (written elsewhere) which performs the multithreaded calls for you. Just make sure to marshall everything back to the calling thread, somehow (probably polling against your COM object, or something similar).

Also, you may want to check out bendewey's link on COM threading, since it's very relevant to this.

Answer 5

If MS Access VBA lets you use forms, drop a timer on a form and set the delay to a really low value, like 10 ms. Then place your code in the timer event function, and it will be executed in a separate thread.