[AccessD] Err object

John,

Yes - it does!

I use a variable to carry the error number and the error description.  I've
been using a Global variable because the value is always reset before each
use.


ErrorHandler:

	GlngErrorNumber = Err.Number
	GstgErrorDescription = Err.Description

	Select Case GlngErrorNumber
		Case 10
			...
		Case 20
			...
		Case Else
			Call ErrorLogging(GlngErrorNumber,
GstgErrorDescription)
	End Select

End Sub


HTH!
Dan Waters

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Monday, November 21, 2005 10: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