Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic Error Handling (XP Sp1)

    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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

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

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

    Re: Automatic Error Handling (XP Sp1)

    Naughty! You're supposed to add the error handling as you go along. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

    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

  5. #5
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

    You are indeed a cruel task mistress.

    Yes I know, I'm slack.

    Ken. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22> <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

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

    Re: Automatic Error Handling (XP Sp1)

    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.
    Charlotte

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

    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 crogram 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.

  8. #8
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

    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

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

    Re: Automatic Error Handling (XP Sp1)

    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.
    Charlotte

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

    Re: Automatic Error Handling (XP Sp1)

    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.
    Charlotte

  11. #11
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

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

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

    Re: Automatic Error Handling (XP Sp1)

    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 <img src=/S/grin.gif border=0 alt=grin width=15 height=15>), so I haven't done any looking around for tools. That's why I believe it's part of the original package.
    Charlotte

  13. #13
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

    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

  14. #14
    2 Star Lounger
    Join Date
    May 2002
    Location
    Dubai, UAE, United Arab Emirates
    Posts
    105
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic Error Handling (XP Sp1)

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

  15. #15
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Automatic Error Handling (XP Sp1)

    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/. You may want to check it out & see if it meets your needs. (If not you can always demand a refund.)

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
  •