/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 vote328 views2 answers
Vba find last row in range for certain criteria
VBA
1 vote289 views1 answer
Change the first item in a queue vb.net
VBA
0 vote289 views1 answer
Excel run macro every 5 minutes
VBA
0 vote302 views1 answer
Build an index all files of a FTP site
VBA
0 vote292 views1 answer
How to get value from clipboard in vbnet
VBA
0 vote309 views1 answer
Remove last 8 characters from string vb
VBA
1 vote286 views1 answer
Sort using vba
VBA
0 vote305 views1 answer
Date as number vb
VBA
0 vote295 views1 answer
Excel vba join variant array
VBA
0 vote317 views1 answer
Make your computer talk vbscript
VBA