[AccessD] Common error number

I think the best use of Raise is for custom, developer defined errors, so
you can get out of a Function or Sub gracefully without writing crap like
Exit Function after testing a condition.
Ex:
If Dir(stFileName) = "" Then
Err.Raise vbobjecterror+1
...
Select Case Err
Case vbobjecterror+1
Msgbox "file Does Not Exist"

Hth
Steve 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Friday, December 08, 2006 12:08 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Common error number

I need a common error number for an example using Raise. I can't come up
with one that shows anything interesting! ;) 
 
Susan H. 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com