/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

0 vote133 views1 answer
Excel vba concatenate range
VBA
0 vote151 views2 answers
Open url from vba
VBA
0 vote164 views1 answer
Vba cell all borders
VBA
1 vote135 views1 answer
If inputbox cancel vba
VBA
0 vote155 views1 answer
Delete all controls in an area vb
VBA
0 vote140 views1 answer
Get month number from month name vbnet
VBA
0 vote140 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote140 views1 answer
Excel vba disable keyboard input
VBA
0 vote134 views1 answer
Vba code to select image in sheet
VBA
0 vote186 views1 answer
Find control with name vb
VBA