nakedbamboo
Technical User
I am trying to remember the way to get an error number so that I can figure out how to skip it if it comes up.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Private Sub ProcName()
On Error GoTo Error_Handler
<your code>
Exit_ProcName:
Exit Sub
Error_Handler:
Select Case Err.Number
Case ERR_DEL_NOT_DONE_YET
DoEvents
Resume
Case ERR_TYPE_MISMATCH
Resume Exit_ProcName
Case ERR_UNKNOWN_TABLE_COLUMN
MsgBox "this type of error shown here"
ColName = DefaultColumnName
Resume Next
Case Else
ErrMessage "", (Me.Name & ".Form_AfterDelConfirm")
Resume Next
End Select
End Sub
Global Const ERR_TYPE_MISMATCH = 13
Global Const ERR_DEL_NOT_DONE_YET = 2105
Global Const ERR_UNKNOWN_TABLE_COLUMN = 3265
Global Const ERR_SAVE_BEFORE_REQUERY = 2118
Global Const ERR_FORM_INVALID_REFERENCE = 2455