/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

22 votes333 views1 answer
Xlvba check for folder
VBA
3 votes201 views1 answer
Extract word in a text in excel
VBA
0 vote180 views1 answer
Vba simple quote
VBA
0 vote187 views1 answer
Supprimer la valeur de celule vba
VBA
0 vote186 views1 answer
Vbscript check if string contains
VBA
0 vote174 views1 answer
Compare dates vb
VBA
0 vote174 views1 answer
Vb streamreader
VBA
0 vote177 views1 answer
Make your computer talk vbscript
VBA
0 vote178 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote187 views1 answer
Excel vba textbox forecolor disabled
VBA