/VBA/How to do error handling in access vba

How to do error handling in access vba

1 Sub|Function SomeName()
2     On Error GoTo Err_SomeName          ' Initialize error handling.
3     ' Code to do something here.
4 Exit_SomeName:                          ' Label to resume after error.
5     Exit Sub|Function                   ' Exit before error handler.
6 Err_SomeName:                           ' Label to jump to on error.
7     MsgBox Err.Number & Err.Description ' Place error handling here.
8     Resume Exit_SomeName                ' Pick up again and quit.
9 End Sub|Function

Similar codes

0 vote233 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote219 views1 answer
Excel delete ever other vba
VBA
0 vote210 views1 answer
Vba shape transparent
VBA
0 vote193 views1 answer
Vba code to open a file with login rights
VBA
5 votes221 views1 answer
Excel vba low byte from INTEGER
VBA
0 vote216 views1 answer
Returns an array from function vba
VBA
3 votes208 views1 answer
Excel vba last row in range
VBA
-1 vote226 views1 answer
Code for reading letters only in vb 6
VBA
5 votes235 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote207 views1 answer
Excel vba range contains
VBA