• 2007 Add-in dialog “Subscript out of range” prob

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » 2007 Add-in dialog “Subscript out of range” prob

    Author
    Topic
    #467237

    Access 2007, fully patched, on Vista-64 likewise. I wanted to use Helen Feddema’s LNC Renamer, part of my basic toolkit but I’d not been developing for a while, so I downloaded the latest version from her site, put it in the AddIns folder, went to Access Options, Add-ins, chose Access Add-ins, Go and up pops the Add-in Manager.

    However, I notice that Rick Fisher’s Find and Replace, already installed, isn’t showing. No problem, I think, he did warn that it’s not tested for 2007, but it works ok. However, if I click on the empty list-box, or on Add New, all I get is an Microsoft Office Access dialog politely telling me Subscript out of range. Ok.

    Pfft. NOT ok!

    I’ve run a repair install of Office Ultimate, in case, but that made no difference. A long look around the internets with Google found a hint that someone once on a time had had a problem with the built-in acwztool.mde that was fixed by a repair install. So I tried a repair install but nada.

    I’ve got a chunk of paid work to do, and I don’t fancy doing it without my usual rig of add-ins.

    Any ideas?

    Viewing 0 reply threads
    Author
    Replies
    • #1212782

      It appears to me that the latest version of the LNC Renamer may not be compatible with 2007 based on Helen’s description in her Summary on her Code Samples page:

      An add-in that renames database objects (tables, queries, forms, reports, macros and modules), as well as controls on forms and reports, according to the Leszynski Naming Convention (LNC). The Access 97 version of this add-in was originally featured in a three-part article series in Smart Access, in the summer of 1998. Now supports your own custom LNC tags. The zip file includes a trial version of Rick Fisher’s Find And Replace add-in. Works in Access 2000 through 2003.

      (Emphasis added for this post)
      If your client is using 2007, you might want to consider doing the development in 2002 or 2003 and then moving it to 2007. Note however that there are some user interface changes in 2007 that you may encounter. Allen Browne’s Converting to Access 2007 is a good resource for what has changed in 2007.

    Viewing 0 reply threads
    Reply To: 2007 Add-in dialog “Subscript out of range” prob

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

    Your information: