/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 vote158 views1 answer
Change form background image vb
VBA
0 vote161 views1 answer
Vba remove last vbcrlf
VBA
0 vote164 views1 answer
VBA OR vb6 find OR replace string from the end
VBA
1 vote147 views2 answers
Get all column names from excel vba
VBA
0 vote164 views2 answers
Open url from vba
VBA
0 vote166 views1 answer
If statement vdhl
VBA
0 vote155 views1 answer
Remove first character from string vb
VBA
0 vote151 views1 answer
Vba add month to date
VBA
0 vote156 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote156 views1 answer
Ribbon show/hide
VBA