TM VBA-Inspector

When coding it's easy to make small mistakes. Usually these errors have no direct effect, the code runs and everything seems to be o.k. That makes this situation so dangerous.

Over the years, you collect a lot of experience when coding. If you later review the code you wrote years ago, you surely will see potential for improvement. When you take over an application someone else has written, the situation becomes even more confusing. Here your success depends on how well your predecessor has complied with the rules and general knowledge.

If you want to gain a quick overview of potential errors you can use the TM VBA-Inspector. This Add-In let's you browse the entire VBA code of an application for potential errors.

Because there are different views about what constitutes an error and what not, you can toggle every single failure in the Options dialog to fine-tune the TM VBA-Inspector to your individual needs and your own coding style.

TM VBA-Inspector provides the following possibilities:

• Detailed list of all "errors" found in the VBA code.
• By double clicking on an "error" you jump to the corresponding line in the VBA code.
• Your settings in the Options dialog box determine which errors will be reported.

TM VBA-Inspector is an Add-In for the VBA Editor and can be used in Access 2000 and later versions.

Since version 1.45.50 the VBA code in Word, Excel and Powerpoint can also be investigated.

You can find more informations on the use of the TM VBA-Inspector in this article on the Access Team Blog.