Avatar of mlcktmguy
mlcktmguy
Flag for United States of America asked on

Getting Warning Message Using VBA MZTools 3.0 in Access 2013

I purchased and have been using VBA MZTools 3.0 for many years, since developing in Access 2003.  It is a great product.

I am now developing in Access 2013 and have upgraded some of the old 2003 apps to 2013.

MZ tools seems to wok fine but whenever I exit Access I get a message:

'VBA MZ-Tools 3.0' has caused an access violation'.  Remove it from the list of available Add-Ins?'

I can then click Yes, No or Help.  Pressing Help takes me to a Microsoft Docs page for Visual Studio 2012 but doesn't really explain the issue.  At least not that I see.

Is there some way to get rid of the message I'm getting when I exit while using Vers 3?  Is there any problem with continuing to use vers 3 if I just answer 'No' to the prompt I get every time I exit Access?

I figured I'd for sure gotten my moneys worth out of vers 3.0 so I decided to move to the newest version.  I didn't see any versions specific to VBA so I downloaded 'MZTools8VB6' but when I try to install it I have an issue.
Microsoft AccessVBAMicrosoft Visual Studio

Avatar of undefined
Last Comment
mlcktmguy

8/22/2022 - Mon
Jim Dettman (EE MVE)

Is there some way to get rid of the message I'm getting when I exit while using Vers 3?  Is there any problem with continuing to use vers 3 if I just answer 'No' to the prompt I get every time I exit Access?

 No way to get rid of the message. There was a change required for the 3.0 version to work with later versions of Access.  Just answer no to the prompt.

I didn't see any versions specific to VBA so I downloaded 'MZTools8VB6' but when I try to install it I have an issue.

  Not sure what's up with that...it should work fine.

Jim.
Daniel Pineault

I've used Mz_Tools (VBA V3 was free) for years and I too, and others, have encountered this error.  To my knowledge there is no fix.  You'd need to upgrade/buy version 8.
mlcktmguy

ASKER
Thanks Jim, I like Vers 3.0 and it does what I need it to do.  I use it heavily to insert Error handling.

Good ot know it's not causing issues other than the annoying message.

When I try to install Ver 8 for VB6 I get ot the screen below.




It looks good but I canot click in the box to select the component I want to install so the 'Next' button is never enabled.
EEMZToolsIsue.jpg
Your help has saved me hundreds of hours of internet surfing.
fblack61
Jim Dettman (EE MVE)

There was a fix, but Carlos took it down when he started charging and it was only available for a short time.   Not many have it.

Jim.
Jim Dettman (EE MVE)

When I try to install Ver 8 for VB6 I get ot the screen below.

 Just as a shot in the dark; are you doing a right click and "Run as admin"?

Jim.
mlcktmguy

ASKER
Yes, I right click the downloaded 'MZTools8VB6Setup.exe' and 'Run as Administrator'.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Jim Dettman (EE MVE)

Do you have 64 bit Office?   not sure what flavors MZ tools comes in.

 Outside of that, out of ideas as I don't have it here.  

Jim.
ASKER CERTIFIED SOLUTION
Daniel Pineault

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mlcktmguy

ASKER
Thank You.