Error Handling in MS Access
My Journey with Camtasia
These are some of the first videos I did using a program called Camtasia. I made them in 2007, and I am keeping them for nostalgia. 😌 Really, I need to update these and add some more videos because this is a very interesting subject 🎯 – error checking in Microsoft Access, indeed in any programming language. 🖥️
Error Checking: The Tightrope Walker’s Net for Programmers
Error checking is the tightrope walker’s net for programmers. You could manage with an old football goal-net ⚽, but you are better off with a more sophisticated net. It’s definitely 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)
… …
