When coding, tiny mistakes slip in all the time. Usually they don’t break anything — the program runs, and everything looks perfectly fine. But that’s the trap: hidden errors are the most dangerous ones, because they strike when you least expect it.

With every year of coding, your experience grows. Look back at something you built long ago, and you’ll almost certainly find things you’d do differently today. But taking over someone else’s application? That’s a whole new level of chaos. Your success hinges on one thing: how well the original developer respected conventions, structure, and shared knowledge.

If you want a fast way to spot potential errors, try the TM VBA‑Inspector. With this add‑in, you can sift through the entire VBA codebase of an application and immediately see where hidden problems might be lurking.

Developers don’t always agree on what counts as an error. That’s why the TM VBA‑Inspector lets you switch each check on or off in the Options dialog. You can tailor the tool exactly to your workflow and coding style.

TM VBA‑Inspector offers the following functionality:

• A clear, structured list of every potential issue found in your VBA code.
• A double‑click instantly takes you to the exact line where the problem occurs.
• The Options dialog lets you decide which types of errors should be shown.

TM VBA‑Inspector is an add‑in for the VBA editor and works with Access 2000 and all newer versions.

With version 1.45.50, the tool expanded its capabilities: you can now inspect VBA code in Word, Excel, and PowerPoint as well.

More details on how to use TM VBA‑Inspector can be found in the Access Team Blog article.