Is a global "replace" possible?

  • Thread starter Thread starter Bill Mitchell
  • Start date Start date
B

Bill Mitchell

Occasionally, I want to change the name of one of my
forms. Going back and changing the name of that form in
every one of my queries is a major pain.

Is there some functionality in Access that will allow me
to globally change the name of a form in all queries in
which it appears? Some sort of 'replace' function?

Also, I tried to do a simple 'replace' (ctrl h) when I
was in sql view and it wouldn't work for each individual
query. I was left with having to copy the sql text,
paste it into word, do a replace then copy and paste it
back. I hope that MS has provided a more elegant
solution than this. Please help!
 
Access 2000 and 2002 both have renaming capabilities, but they have
limitations. It sounds like you have a wealth of parameter queries that
reference Form names. I don't think the feature works against those.

So, you can either write a little VBA code to open the SQL of each querydef
and change it, or you can buy Speed Ferrett by Black Moshannon, which will
do it for you.
http://www.moshannon.com/speedferret.html

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top