Recommended Tools

This is a list of some FREE tools I have used, and why I find them useful  Sure you can do without these tools, but each of them can help you add some quality or speed to your project, so why not take advantage of these options when they are right there in front of you?

I will ONLY recommend tools I have used or are using, and at the moment only freeware/donationware tools.


MZ Tools for VBA (3.0)

This is a very useful tool for writing code faster, and reusing code snippets and templates. It has features to add error handling to your code. It makes it much easier to keep your code consistent.

MZ-Tools 3.0 is a freeware add-in for Visual Basic 6.0, Visual Basic 5.0 and the Visual Basic For Applications editor (provided by a VBA-enabled application such as those in Office 2000-2013 32-bit, except Office 64-bit) which adds many productivity features to the IDE.

MZ-Tools have alot of functions, but the ones I use and like are the templates for Module/procedure headers, and error handlers. It also has a function “Procedure Callers” that will conveniently list all the places in your code in which a function is called. (I don’t think this includes function calls from a controls controlsource)

The MZ-Tools also has a code review feature which will point out certain issues that could potentially become a problem. It is a nice way to improve the quality of your code.

MZ-Tools can offer alot more, but I haven’t yet tried all it. MZ-Tools is free and certainly worth giving a go, if you are serious about writing VBA code.

Team Moellers VBA Inspector

This is another tool for looking through your VBA code and spot potential pitfalls or performance enhancements.

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.

This will give you a very quick overview of places to make improvements. You can also set options on which type of errors you want to check for, or even exclude entire modules from the check. Note that these are recommendations  and not as such rules set in stone. There are rules, and every rule has an exception. But I’ve found it very instructive to work with this tool, and it really helps me hone my skills, and improve code quality.



6 comments on “Recommended Tools
  1. FAP says:

    I would like to know how to create a recorset of selected records in a MS Access query or datasheet view, basically I want to use a form with a embeded datasheet / query and a button; once some records are selected then the user can press the button and the recordset is created. In advance thank you for your help.

    • TheSmileyCoder says:

      Hi Fabio
      Let me make sure I understand you fully, you want to be able to make a multiple record selection, and then make a new recordset based on those selections, such that the new recordset can be used for example: Printing, another form, or whatever. Is that correct?

  2. José Antonio says:


    • TheSmileyCoder says:

      If your looking to store in a OLE field, I believe Stephen Leban has some code on his site you might be able to use.
      I’ve been working on a solution that stores various sizes (Original, Report size and Thumbnail) on a network drive, and stores the information required to retrieve the picture in a table. But I’m not quite ready to post that yet.

  3. sameh says:

    hi can i cancel changes in all forms ( main form and continuous sub form) ..if save button is not clicked..??

    • TheSmileyCoder says:

      There really isn’t no easy way to do that. Access works on a per form basis. So you can cancel “a” record at a time. Either the main form, or “a” record in the subform. There is no way to cancel all changes e.g. since the form opened. If you want that functionality you will have to code it yourself, by e.g. using temp forms. It can certainly be done, but it is alot more work than standard Access development.

Ask a question, leave some feedback, post a reply!