/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

8 votes189 views1 answer
Run command pormpt in background windows
VBA
0 vote184 views1 answer
Excel vba DisplayAlerts
VBA
0 vote170 views1 answer
Make your computer talk vbscript
VBA
0 vote157 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote150 views1 answer
Style percent not found vba
VBA
0 vote169 views1 answer
Vba get application version
VBA
2 votes189 views2 answers
Excel vba if sunday or staurday
VBA
0 vote165 views1 answer
Visual basic msdos
VBA
0 vote163 views1 answer
Type excel.application is not defined vb
VBA
0 vote181 views1 answer
How to add line graph vb net
VBA