Background processes in VBA

G

Guest

I have a switchboard form that when I press a button it starts a background
process that executes until a certain condition is true. In the meantime I
need the user to be able to perform other tasks, namely use other forms.

Is this easily doable?
 
G

Graham R Seach

Mikael,

No. Access doesn't support threading. Any "background" code you start
running will take over the application until it finishes. The exception is
events. Events will always interrupt anything that is currently running, and
the event code will then run until *it* finishes, after which, control will
revert to whatever was running previously.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running process in the Background 5
Disable background form when showing a wait cursor 0
Background process in Visual Basic 6/VBA 1
Change background color of a cell in datasheet view 1
Thread Programming - Background Processes 2
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
Access 2007 Switchboard buttons stop working 3
vba loop 3

Top