Tool Or Utilty To Global FIND and Replace - Wanted - Any Suggestions

[MarkDicken]

Many moons ago using MS Access 2.x I had a utility that would do a global find and replace. Does anyone know what it is or can anyone reccomend a product. I need a Access 2000 version now.<br><br>Many Thanks In Advance ...<br><br>Mark Dicken - Contractor<br>Email <A HREF="mailto:markd@trainingserve.com">markd@trainingserve.com</A>

 

[DougP]

I guess you are talking about finding data in your table not code in VBA???<br><br>In a table:<br>Open your table and Click in the column you want to replace stuff.<br>then click &quot;Edit&quot; menu then click &quot;Replace&quot;<br><br>Or Ctrl-H <br>Or if you click the Top of the column so it's completely highligthed all the way down, then Right click and you will see find with Binoculars which has the replace TAB in it.<br>Also there are a pair of binoculars in the menu above which has the replace added to it too.<br><br>OK <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[MarkDicken]

Thanks for your comments DougP but It is the VBA Code and QueryCriteria's and Form Names and Modules that need replacing.<br><br>A good example is I once spelled 'tblAccountant' wrong. I had created forms and queries and modules of VBA code that pointed to the mis-spelled table name. The utility is very powerful but also harmful if not used correctly.<br><br>Many Thanks In Advance for any answers ...<br><br>Regards<br><br>Mark Dicken - Contractor<br>Email <A HREF="mailto:markd@trainingserve.com">markd@trainingserve.com</A><br>

 

[Geekette]

dear mark,<br>i have had excellent results with a lovely utility named appropriately, <i><b>&quot;find and replace&quot;</i></b>.<br>the programmer, rick fisher, has versions for 2.0, 97 and 2000. you can purchase all three for under $50; separately they're about $20 each.<br><br>his website is <b> <A HREF="

http://www.rickworld.com"

TARGET="_new">

http://www.rickworld.com</A></b><br><br>his

email is&nbsp;&nbsp;<b><A HREF="mailto:rfisher@rickworld.com">rfisher@rickworld.com</A></b>

 

[MarkDicken]

Thankyou Geekette - Just What I Was After ... (Find and Replace)<br><br>Regards<br><br>Mark Dicken

 

[elizabeth]

BTW there is a <b>new</b> Name Autocorrect feature in Access 2000. This works at the object level and in queries, but I have to use Access's own &quot;Find & Replace&quot; for references in the code.

 

[skeddy]

I remember a product called Speed Ferret that also did the same thing.

 

[MarkDicken]

Anyone know of &quot;Speed Ferret &quot; ???<br><br>Regards<br><br>Mark Dicken

 

[elizabeth]

Yes, it's by Black Moshannon. It's a great product for Access97 or earlier but they don't have the Acesss 2000 version yet. Speed Ferret does more than Find & Replace, it has a great reporting feature than allows you to review where each instance is used and replace just selected ones. <A HREF="

http://www.speedferret.com"

TARGET="_new">

http://www.speedferret.com</A>