VBA + Threads in MS Access [duplicate]

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

You might want to check out this workaround: http://www.excelhero.com/blog/2010/05/multi-threaded-vba.html

It is Excel, but it should be practically the same. It works by building VBScript "agents" and have them execute tasks.. Check the example, it is quite impressive

-Viggo