Bug Types - No Longer Set

Why You Should Learn to Love Syntax Errors

The immediate negative feedback loop that syntax errors provide is a powerful learning tool.

Five Ways to Turn Runtime Errors into Compile Errors in VBA

Compile errors are cheaper and easier to fix than runtime errors. Here are five ways to turn potential runtime errors into compile errors.

Defensive Programming

Five Ways to Turn Logic Errors into Runtime Errors in VBA

Runtime errors are cheaper and easier to fix than logic errors. Here are five ways to make that happen.

Defensive Programming

5 Ways to Reduce Logic Errors Using Automated Double-Checks

Identify the critical functions in your application. Then, apply one or more of these techniques to ensure that if they break, someone will notice.

Bug Types

"It Runs On My Computer"

Here are the 7 most common reasons I've had to utter those words as an Access developer.

Bug Types

Misunderstood Requirements (After You've Written the Code)

As you install the final piece of crown molding in the dog's second bedroom, you can't help but smile at the absurdity of it all.

Bug Types

Runtime Errors

It's impossible to predict every possible scenario that could befall our applications in the wild. But we need to at least try.

Bug Types

Logic Errors

The logic error is the most dangerous and insidious of all software errors.

Bug Types

Automated Test Errors (aka, Failing Tests)

You can have a bug in your code and/or in your test. You're unlikely to have the *same* bug in your code and your test.

Bug Types

Misunderstood Requirements in the Project Design Phase

Your client knows what's wrong. They *think* they know how to fix it. But treating symptoms is never as effective as treating the disease.

Bug Types

Compile Errors

Compile errors are easy to keep out of deployed code (just remember to Debug > Compile). Which is good because they hard crash Access in Runtime mode.

Bug Types

Syntax Errors

Every programming language has its own syntactical quirks. The C family loves braces. Python loves indentation. BASIC loves words. And Perl loves #%@!{}]&.