• Automatic Error Handling (XP Sp1)

    Author
    Topic
    #371946

    G’day All

    Some time ago (Access 97?) I used to have a utility (I think it was an Access addin) that would whip through a module and add error handling code to all the Events/Subs/Functions in the module, be it attached to a form, report or whatever. Nothing fancy, just the basic error handling you get when you create a command button with the wizard.

    Well, I recently went looking for it and can’t find it anywhere. I re-install my machine perhaps three times a year and I’m usually pretty religious about keeping track of stuff like this but it’s gone.

    Does anyone have an idea what I’m referring to (I can’t remember where I got it) or can someone suggest anything that would do this for me in Access XP ?

    Regards Ken

    Viewing 1 reply thread
    Author
    Replies
    • #592882

      The only addin that I know is Total Visual Code Tools.
      Excellent but not cheap

      • #593058

        G’day Francois – thanks for the reply.

        I had a quick look (I’ve seen the adds in various AccessVB magazines) – You weren’t kidding about not being cheap. I might hunt around for some shareware to do it. I’m pretty sure what I used to usewas part of a “Code Library” utility that came onsome kind of office/access developer cd. I’m going to hunt back through my cd’s too.

        Regards Ken

    • #593055

      Naughty! You’re supposed to add the error handling as you go along. laugh

      • #593057

        You are indeed a cruel task mistress.

        Yes I know, I’m slack.

        Ken. crybaby bagged surrender

        • #593064

          The VBA Error Handler add-in is still there in Access 2000. Are you sure it’s missing from XP? I can’t remember whether you had to select it in setup or not and I don’t have Office XP on this machine so I can’t check, but if it doesn’t show up in the Add-In Manager list then it simply may not have been installed.

          • #593065

            G’day Charlotte

            I have nothing in the Add In Manager at all. I’ll pull out my Office XP disk and check – but it would be extremely unusual for me to do an incomplete office install. I usually stick with the custom options all the way and ensure all options are ticked. But there’s always a first time …

            I’ve also bee through the “Office Tools 2002” and “Office XP Resource Kit” and “Office XP Power Packs” CD’s I have to no avail.

            I’m hunting through my c:program files tree for *.mda and *.mde files to see if there are addins not currently referenced. If you have any other ideas, I’d appreciate them.

            Regards Ken.

        • #593077

          Ok, well, found the error handler (and the Code Librarian) as part of the Office 2000 Developer CD. However it refuses to install and after some playing around I don’t think I can get the components to run either. I guess I’ll have to hunt round for the XP version.
          Regards Ken

          • #593130

            You’re right, it is a developer tool. In XP, the Code Librarian is an entirely separate application and much more complex than the relatively simple EXE/MDB combination in the 2000 Developer tools. Don’t look for mda file, those are generally add-ins for the user interface anyhow. I’ll check my machine at work to see if I have an error handler as an add-in in the Access 2002 VBE.

          • #593161

            See if you have the MZ-Tools add-in in Access XP. If it’s loaded, it will show up on the tools menu. You can use it to add error handling to any procedure.

            • #593176

              No, it’s not there. Where does it come from ?

            • #593313

              Well, it’s in my office machine’s Add-In Manager in the VBE and I believe it’s part of the developer tools for XP. I can’t check until after the weekend, but the only other place it could have come from is from the Microsoft site. I don’t actually use AXP at work yet (that will be the next but one version of our application grin), so I haven’t done any looking around for tools. That’s why I believe it’s part of the original package.

            • #593353

              Thanks for your checking. I’m off to Bangkok tonight so I’ll look around and see how much the Developer Tools are for XP. MS has them for 500+ dollars, which is a little expensive for Code Librarian.
              Code Librarian is mentioned specifically on the MS web site for XP Developer Tools by the way. The screen shot shows that the ap has developed long past what it was in A2k. Actually I have visual studio here somewhere – I should check and see if it’s part of that …
              Regards Ken

            • #593354

              Also – maybe your Access XP at work was an upgrade – therefore the Code Librarian tools may have been carried through.

            • #593394

              No, the work setup was a clean install. I did it myself. Also, the CodeLIbrarian in XP is entirely different from its 2000 cousin.

              I had understood you to *have* the Developers Edition of XP. The MZ-Tools and Code Librarian are part of the developer tools that come with MOD. I would be extremely wary of picking up what might be a pirate copy in Bangkok, if I were you.

              Edited later
              Correction – MZ-Tools is NOT part of the developer tools, it’s freeware. See MarkD’s post.

            • #593372

              MZ-Tools is a freeware VB/VBA add-in that’ll do a lot of stuff the FMS utilities do w/o relieving your wallet of $100’s of dollars (or whatever your local currency is). The web site is located at http://www.k-offline.com/mz-tools/%5B/url%5D. You may want to check it out & see if it meets your needs. (If not you can always demand a refund.)

            • #593395

              Thanks, Mark. I don’t know how I happened to have it then. I can’t recall installing anything like that, since I don’t even use AXP at work, but apparently I did. shrug

              Edited later
              Aha! I must have installed it for VB6 and carried it over.

            • #593428

              G’day Charlotte

              No I have the Developer Tools for Access 2000 (A client bought it for me when he needed standalone Access applications without having Access installed). I don’t have Developer 2000 installed (fresh install of Office XP) and don’t have the Code Librarian associated with either version.

              From my reading of the MS web site – you must have Access/Office XP developer tools installed to have the Code Librarian …

              Must be from VB6.

              Ken

            • #593445

              Are we still talking about MZ-Tools or about Code Librarian? I believe I installed MZ-Tools for VB6, which is why I didn’t recall downloading anything for AXP.

              Code LIbrarian comes with Office Developer, and you have to install it. In some ways I prefer the 2000 version of Code Librarian, but the XP version has a bunch of capbilities I haven’t been able to explore yet and is vastly different from the fairly simple VB/MDB application in the 2000 version.

            • #594061

              To new Code Librarian does look complex. I miss the days of manuals when I could go to a coffee shop with a book and browse through it to get the feel of software instead of wasting time learning software in front of the keyboard.
              Regards Ken

            • #594105

              It is complex and it doesn’t use color in the code (like the VBE does) the way the 2000 version did, which was disconcerting at first; but you can have multiple libraries loaded and do a bunch of other stuff you couldn’t do with the previous version.

            • #594081

              I would heartily concur.
              MZ-Tools is a great bit of kit trophy which has saved me hours of tedium and found a few problems waiting to happen. Go for it!

            • #594071

              MZTools is great, it adds error handling and comments, and all kinds of other goodies.

    Viewing 1 reply thread
    Reply To: Automatic Error Handling (XP Sp1)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: