D
Dave Elliott
Can I replace this with my own error message?
MsgBox Err.Description
MsgBox Err.Description
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
Yes. Generally, you trap for specific error numbers and leave the MsgBox
Err.Description for any other cases. Like this:
If Err.Number = 3265 Then '*** if the error is the query is missing
MsgBox "There is no such query."
Resume Exit_cmdRunQuery_Click
Else
MsgBox Err.Description '*** write out the error and exit the
sub
Resume Exit_cmdRunQuery_Click
End If
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Err.Description for any other cases. Like this:
If Err.Number = 3265 Then '*** if the error is the query is missing
MsgBox "There is no such query."
Resume Exit_cmdRunQuery_Click
Else
MsgBox Err.Description '*** write out the error and exit the
sub
Resume Exit_cmdRunQuery_Click
End If
--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L