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?