Error Handling - No Longer Set

ComboBox NotInList Event: Revisited

We improve our NotInList event code with a workaround for the "text you entered isn't an item in the list" error message via the little-known Form Error event handler.

Error Handling

The Form Error Event: How to Handle "Untrappable" Access Errors

The Form Error event comes to the rescue for a category of errors impervious to `On Error Resume Next` and `DoCmd.SetWarnings False`.

Error Handling

Showing User-Friendly Error Messages for Missing Data on Bound Forms in MS Access

Here are two ways to show custom error messages on a bound form using (1) the Form_BeforeUpdate event or (2) the Form_Error event.

Error Handling

Why "Add an Error Handler to Every Routine" is Bad Advice

For every complex problem, there is an answer that is clear, simple, and wrong. (Shocking, I know.)

Humorous

Reproducing Errors

A physicist, a mechanic, and a programmer were in a car driving over a steep alpine pass when the brakes failed...

Signal vs. Noise

Signal vs. Noise: Error Handling

To boost our signal to noise ratio, we can increase our lines of meaningful code or decrease the lines of boilerplate.

Error Handling

Graduate Level Error Handling

Once again, I borrowed an idea from Python. To smuggle this concept into VBA, I turned to a rarely-used language feature...

Error Handling

Throwing Errors in VBA

Introducing a frictionless alternative to Err.Raise.

Error Handling

Error Handling Evolution

How you handle errors says a lot about you as a programmer. Most people evolve with experience in how they handle errors. From the most naïve to the most advanced, here is what that evolution looks like.