MZ-Tools (All versions)

Topic

New Reply

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?

Reply | Quote

Replies

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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!

Reply | Quote

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)

Reply | Quote

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

Reply | Quote

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 ?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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)!

Reply | Quote

It *does* work in the VBA version for VBA forms, e.g. userforms in Word and Excel. It does *not* work for Access forms, because they are not VBA forms.

Reply | Quote

It *does* work in the VBA version for VBA forms, e.g. userforms in Word and Excel. It does *not* work for Access forms, because they are not VBA forms.

Reply | Quote

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)!

Reply | Quote

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?

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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 ?

Reply | Quote

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

Reply | Quote

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)

Reply | Quote

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!

Reply | Quote