Windows 7 Professional 64 Enhance the quality of y

Today’s guest blogger is Access MVP Thomas M"oller,Office Professional 2007 Key, an Access MVP since 2007,Office Professional 2010 Key, and an avid developer of Add-Ins to enhance Access and the VBA Editor. Check out his website at When coding, it's easy to make small mistakes. Usually these types of mistakes have no direct effect; the code runs and everything appears to be OK. 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 free TM VBA Inspector. This add-in lets 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. How to install TM VBA-Inspector? You can download the TM VBA-Inspector from this location:
The Add-In is free of charge,Microsoft Office Professional 2010 Key, and has been tested to work with Access 2000 through Access 2010. Unzip the file and run the *.msi-package. This will install the Add-In on your system. Note that you might need to confirm Yes to install prompts if Windows User Account Control is on. How to start TM VBA-Inspector? There are three ways to start the tool. You can either choose TM VBA-Inspector from the Add-Ins menu,Windows 7 Home Premium 64, or you can start TM-VBA-Inspector from the context menu of any code window. In these two cases the main window of the Add-In will open. The third way is to select a module in the Project Explorer. Then start TM VBA-Inspector from the context menu. In this case the TM VBA-Inspector will start directly with the inspection of the selected module. How to work with TM VBA-Inspector? Select the tests you want to run from the Options dialog. Then start the audit of your VBA project by clicking on the Refresh button. Step by step, the hints are entered into the result list. Depending on the size of your project,Windows 7 Professional 64, the audit might take several minutes. You can interrupt the audit at any time by clicking the Stop button. By double-clicking an entry in the result list you switch directly to the appropriate place in the VBA code. There you can start immediately eliminating the identified errors. Enjoy! <div