/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

-1 vote255 views1 answer
Vba sendkeys
VBA
0 vote242 views1 answer
Vba copy file
VBA
0 vote229 views1 answer
Rotate image by any angle vb.net
VBA
0 vote223 views1 answer
WGET FTP
VBA
0 vote223 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote221 views1 answer
Type excel.application is not defined vb
VBA
0 vote303 views1 answer
Excel vba add reference programmatically
VBA
0 vote240 views1 answer
Vba html document reference
VBA
0 vote226 views2 answers
Excel vba close without saving
VBA
0 vote234 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA