Personalize error message

M

Maria Joao

I need to change an Access Error Message that apears every time I try to
open an hyperlink on the CD, and the CD is not there.

Is there any way to personalize this message to something else?

Thanks

Maria Joao
 
D

Douglas J Steele

The normal approach is to add error handling, and trap the specific error
number that's occurring:


Sub MySub()

On Error GoTo Err_MySub

....

End_MySub:
Exit Sub

Err_MySub:
Select Case Err.Number
Case 1234 ' or whatever the specific error number is
MsgBox "This is my custom error message"
Case Else
MsgBox Err.Description
End Select
Resume End_MySub

End Sub
 
Top