[AccessD] Raising Events in Custom Classes

Bryan,

Yes, it will.  VBA is single threaded, meaning that only a single thread of
code is executing at any given time.  It isn't just your raising events
however, if you were to place a message box asking a user a question in any
event of any form or control, ALL processing stops until the user answers
the question.  If you fire a query in an event that updates a million
records, and that query takes 2 minutes, ALL code stops executing until that
query finishes processing.  Etc.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bryan
Carbonnell
Sent: Friday, October 10, 2003 9:21 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Raising Events in Custom Classes


A quick question about classes and events

If I create a class that has a loop in one of the methods and raise
an event in that loop.

If I have used WithEvents to dim the class and created an event
handler to deal with this event, does the loop code in the class
"pause" while the event handler handles the raised event?

--
Bryan Carbonnell - carbonnb at sympatico.ca
Experience is a wonderful thing. It enables you to recognize a
mistake when you make it again.


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com