/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

9 votes230 views2 answers
Excel vba convert 2 Short integers to a Long integer
VBA
1 vote131 views1 answer
Vba exit do while
VBA
0 vote181 views1 answer
Reference to a non-shared member requires an object reference
VBA
4 votes178 views2 answers
Vba last row
VBA
0 vote179 views1 answer
Excel vba cell on change
VBA
0 vote186 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote166 views1 answer
Excel vba copy entire sheet paste values
VBA
0 vote170 views1 answer
Vba first line of string
VBA
1 vote171 views1 answer
Excel vba first row in range
VBA
0 vote208 views1 answer
Filesystemobject vba reference
VBA