Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Name Autocorrect (Acess XP)

    If the a 'proper' name autocorrect add-on or some thing that would really do the job & name change thro' all of a db including macros? I guess like many 'amateur' Access users I often wish I had named things differently & better!

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

    Re: Name Autocorrect (Acess XP)

    Name Autocorrect is built-in, not an add-in. Name Autocorrect is *supposed* to do that, but I wouldn't rely entirely on it. It also causes your database to bloat unreasonably and, in Access 2000 at least, was implicated in a whole range of odd errors and problems that appeared to have nothing to do with it but were cured by turning it off.

    There are also after-market products like Speed Ferret, from <A target="_blank" HREF=http://www.moshannon.com>Black-Moshannon</A> that allow you to rename after the fact, although I'm not sure how many of them support 2002 yet.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Name Autocorrect (Acess XP)

    I haven't actually tested this yet, but I believe if you save your XP database in Access 2000 format (the default), then Speed Ferret should do the trick. The 2000 version of Speed Ferret was only recently released, but in 97 and prior versions it is an indispensible tool. "Total Access Analyzer" (http://www.fmsinc.com/products/analyzer/) is another package that is useful in finding out everywhere that a name is used.
    Wendell

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

    Re: Name Autocorrect (Acess XP)

    I know that the latest version of Speed Ferret will run on Access 2000 because I use it. However, since it looks at the entire database, including the forms, etc., I would expect that would *only* work on an XP database if you had saved in in 2000 format.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name Autocorrect (Acess XP)

    Thanks for your comments. I'm only an amateur with one db to sort out so I'm reluctant to spend >$100 on the solution & none of the 3rd party products I've been pointed at support Access XP (I know I can save as Acess 2000 change & then convert to XP). I can make autocorrect work for most objects but NOT for macros. eg if I use a macro to open a form & change the name of the form autocorrect will NOT ammend the macro. Is there any solution?

    Ian

Posting Permissions

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