Bulk replace string in an Access 2007 app


I have an application where the word "organisation" occurs in forms, reports and in the code's comment lines. In the code itself this word does not matter.

Maybe I am being optimistic, but is there a mechanism or technique available  to bulk change the word "organisation" to, say, "banana" (I am protecting the innocent here!) wherever it occurs in these places. I am NOT looking forward to going through every inch of this app looking for "organisation" and then laboriously changing it every time...

Many thanks.
Who is Participating?
cquinnConnect With a Mentor Commented:
In that case - there is Total Deep Search in V-Tools

Rey Obrero (Capricorn1)Commented:
better use a third party software "Find and Replace"
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<no points please>

+1 for Find and Replace. It is invaluable for Access development work.
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

There is also MZTools, which has many other useful functions

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I love MZ Tools - without a doubt, the most useful VBA tool collection I've seen - but the find/replace feature only works in the VBA IDE documents. Rick Fisher's works with data, tables, queries, etc etc.
Helen FeddemaCommented:
I agree.  I have been using FAR since the early days of Access, and it is an invaluable tool.  
PeborghAuthor Commented:
Thanks all. I already have MZ-tools but am looking into V-tools because of the coverage of the replace I am after. I'll let you know...

Many thanks,

PeborghAuthor Commented:
Got Vtools, used it for bulk replace and all is well.
useful tool!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.