error handle

[arale]

ok lets say that i have an erron number '-2147467259(80004005)'; and i want to write :

on Err '-2147467259(80004005)'; GoTo idfixer

idfixer:
idfixer:
MsgBox "îñôø ú.æ äéðå ÷ééí âáø áîòøëú àðà äëðñ çãù"
txtid = ""
txtid.SetFocus



whats wrong here?

thank you for your help

[MartinLiss]

You can't go to an error routine based on specific error numbers. Do something like this instead:

On Error GoTo ErrorRoutine

' your code

Exit Sub

ErrorRoutine:

MsgBox Err.Number & ": " Err.Description

End Sub

[arale]

i know that i can do something just for this err number but how you describe the number

[Clunietp]

On Error GoTo Error_Handler


Error_Handler:

Select Case Err.Number
case -2147467259
msgbox "Just what I thought!"
case else
msgbox err.description
end select