Background processes in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top