/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 vote282 views1 answer
Vba horizontalalignment
VBA
0 vote272 views1 answer
Xlbycolumns is not declared
VBA
0 vote273 views1 answer
Get current url vb.net
VBA
0 vote277 views1 answer
Vba first cell in range
VBA
5 votes302 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote283 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
12 votes360 views1 answer
Excel vba write string to text file
VBA
0 vote287 views2 answers
Get unique random number in vb.net
VBA
1 vote269 views1 answer
Sort using vba
VBA
20 votes381 views1 answer
Excel vba recursive example factorial function
VBA