Jim DeMarco
Jdemarco at hshhp.org
Fri Dec 19 13:40:32 CST 2003
Joe, Just put a Msgbox call in there and create and destroy your object and you'll see it fires automatically when the last reference to your class object is destroyed. HTH Jim DeMarco -----Original Message----- From: Joe Rojas [mailto:JRojas at tnco-inc.com] Sent: Friday, December 19, 2003 1:13 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] class module question Hi All, I am reading the wonderful chapter on WithEvents and RaiseEvent taken from the 'Beginning Access 2002 VBA' book that is written by John Colby that was linked to sometime ago. When I was reading it I came across the Sub called 'Class_Terminate()' in one of his examples. Because I don't have the other chapters, I can't tell if this Sub gets automatically called when a class is destroyed or if it needs to be called before it is destroyed. Anyone know? Thanks, JR This electronic transmission is strictly confidential to TNCO, Inc. and intended solely for the addressee. It may contain information which is covered by legal, professional, or other privileges. If you are not the intended addressee, or someone authorized by the intended addressee to receive transmissions on behalf of the addressee, you must not retain, disclose in any form, copy, or take any action in reliance on this transmission. If you have received this transmission in error, please notify the sender as soon as possible and destroy this message. While TNCO, Inc. uses virus protection, the recipient should check this email and any attachments for the presence of viruses. TNCO, Inc. accepts no liability for any damage caused by any virus transmitted by this email. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************