Error Handling in MS Access
These are some of the First videos I did using a program called Camtasia! I did them in 2007, and I am keeping them for nostalgia! Really, I need to get these updated, and add some more videos because this is a very interesting subject “Error Checking” in Microsoft Access, indeed any programming language. Error Checking is the tightrope Walkers net for programmers. You could manage with an old football goal net, but you are better off with more sophisticated net, and much better than having no net at all!
Command Button With Error Code
Command Button With Error Code
Video 1 (3.05)
Demonstration of how to create a command button on an MS Access form with the command button wizard. The significance is that the command button wizard automatically adds error code to the on click event of your command button.
Video 1 (3.05)

… …
Command Button Without Error Code
Command Button Without Error Code
Video 2 (1:52)
By creating a command button without using the command button wizard, you end up with a command button with no error checking code in it.
Video 2 (1:52)

… …
Force an Error WITHOUT error checking
Force an Error WITHOUT error checking
Video 3 (1.45)
Force an error by dividing ten by zero, demonstrate how this code called from a command button without any error checking code in it performs.
Video 3 (1.45)

… …
Force an Error WITH error checking
Force an Error WITH error checking
Video 4 (4.03)
Again generating an error by dividing ten by zero, this time the error is triggered by a command button with error checking code, this shows the user your own custom MessageBox instead of the built in MS Access error message box.
Video 4 (4.03)

… …
Looking at the Code
Looking at the code
Video 5 (3.36)
A detailed look at the error code generated by the Microsoft Access wizard, the “on error” instruction and the “Goto” instruction a brief description of labels and some ideas on how to use the resume statement.
Video 5 (3.36)

… …