Boyd, Mark Thomas (US - Philadelphia)
mboyd at deloitte.com
Mon Nov 21 11:15:55 CST 2005
John - I create a global boolean variable to flag whenever this type of error is encountered. Within the called function's error handler, I update the variable to True. After kicking out of the called function, I immediately check to see that the variable is still False. If True, I don't allow the code to continue. Mark Boyd Senior Consultant Enterprise Risk Services Deloitte & Touche LLP Tel: +1 215 405 5576 mboyd at deloitte.com www.deloitte.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Monday, November 21, 2005 11:54 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Err object I have just discovered that the error object resets the first time an end sub/function is encountered. Thus I cannot even call a function to return my framework class instance since the return of that call clears the error handler. Any comments on how you folks handle error logging given this issue? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]