Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    MZ-Tools (All versions)

    I just downloaded and installed MZ-Tools, and am working through understand its capabilities and how it works. One thing I found immediately is that it would be helpful if the put the message "This feature is not available in the VBA version" at the beginning of the Help message rather than the end!

    My major interest is in use of Error Handling and Procedure Header comments, but I'm wondering what other capabilities have you found to be really useful that might not be apparent to the first-time user?

    Also, I was looking at the use of line numbers (primarily for use in conjunction with error handling), and was wondering how many of you use this?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    New Lounger
    Join Date
    Mar 2002
    Location
    Redmond, Washington, USA
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MZ-Tools (All versions)

    Mark,

    I use the line numbers in conjunction with the error handling for every piece of code I write, they are by far, the functions I use the most. In my error handling routine I log the error number, error description, line number, procedure name, object name, Access user name, network user name, SQL Server user name (if it

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MZ-Tools (All versions)

    Mark,

    The line numbers are primarily a debugging tool, and one I never use. On the other hand, I couldn't live without the Find and the templates for inserting Error Handlers, code snippits, etc. The Copy and Paste controls with code features are very handy, and I like the Add Procedure wizard much better than the built in one. I also like the Add procedure to Favorites and Go to Favorite Procedure tools, which are much nicer than working with bookmarks. I LOVE the tools to clear the immediate window and to collaps the projects. The latter saves scrolling through all the forms to get to a standard module. I like the source code review, which identifies unused variables, uncalled procedures, etc. The statistics are kind of fun, since they tell you how many procedures, code lines and comment lines are in each module. I use this tool every day, and have it on all machines I work with. I hate having to work in A97 because I don't have my MZ-Tools!
    Charlotte

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: MZ-Tools (All versions)

    Kevin,

    Thanks. I was considering beefing-up my own error handling procedures, and it seems like having line numbers would provide much needed information. I'm doing some contract work for a company who just started an option in their error handling procedures that allows the user to submit the error over the internet to an SQL server. Gives them a good handle on what kind of errors are happening, and where.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: MZ-Tools (All versions)

    Charlotte,

    Thanks. I was trying to get a good feel for the various tools, so I could decide whether or not to use the product. I just always hate to invest the time and effort to learn a new product like this only to find out I only use 1 or 2 functions, and the rest just aren't really that useful. (They sound good, but a just clunky when you try to use them!).

    Looks like this one would be worth the effort. Thanks again. (and I was wondering about whether/not this would work for Access97, I didn't remember seeing anything on the website about this)
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MZ-Tools (All versions)

    As far as I know, it is only available for VB 5 and 6 VBA in 2000 and later, when the IDE changed.
    Charlotte

  7. #7
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MZ-Tools (All versions)

    I heard about MZ-Tools before, so I decided this morning to have a look at it.

    I must say I'm impressed, being such an amateur, it has highlited quite alot within my VB (wrong forum I know) Project.

    I liked the "Review Source Code" menu particularly to highlite unused variables.
    One thing before I press the save button, how reliable is this function ? Has it ever been known to hick-up ?

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MZ-Tools (All versions)

    Save? Save what? Are you talking about relying utterly on MZ-Tools when deleting a variable? It depends on how you've coded your project. I always click on each listed item and examine the code myself before taking the next step. I work with VB so rarely, that I can't speak to the tools in that environment.
    Charlotte

  9. #9
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MZ-Tools (All versions)

    Charlotte

    The MZ Tools has the facility to check all code and find any references or variables which aren't linked to anything.

    I was just wondering how reliable it was.
    I to checked the output in case anything within was linked to anything else.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MZ-Tools (All versions)

    You should always be careful, and judge for yourself if the results of MZ Tools' analysis is correct.

    In Access, for example, you can use custom VBA functions in expressions in queries, forms and reports. Since MZ Tools only checks the VBA code, it won't detect if a function has been used in an expression, so it may falsely report that a function is never used.

  11. #11
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: MZ-Tools (All versions)

    I use MZ Tools (with Access 2000) , but I can't work out how to use the 'Copy Control with Code' feature. Whenever I try to use it I get an error message :"There is no Active Designer."

    The onlly place MZTools become available to me is in the VBA Editor. I would expect the place to use Copy Control with Code would be with a form active in Design Mode, but the tools are not available there: no Context Menus, no Toolbar., no Tools...MZ Tools . Should these be available in Design mode?
    Regards
    John



  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MZ-Tools (All versions)

    I think this feature is meant for VBA UserForms in Word and Excel. Those are designed and edited in the VBE environment. You can copy a control, for example a command button, complete with its On Click event handler from one UserForm to another. Access forms are quite different from VBA UserForms.

  13. #13
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: MZ-Tools (All versions)

    That makes sense Hans.

    I wondered if it was supposed to allow me to Copy a Command Button (complete with code) from one Access form to another. I would find that very useful, to avoid having to copy the code separately.
    Regards
    John



  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MZ-Tools (All versions)

    That would be useful indeed, but I'm afraid it's outside the scope of MZ-Tools.

  15. #15
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: MZ-Tools (All versions)

    The "Copy Control with Code" is one of many features that does not work with the VBA editions of MZ-Tools. It is hard to figure this out, as the notice that a feature isn't available is only found at the very end of the Help screen for that feature. So unless you scroll all the way to the end of the help message, you probably will miss it (as I first did)!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •