• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 331
  • Last Modified:

Bulk replace string in an Access 2007 app

Guys,

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.
0
Peborgh
Asked:
Peborgh
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
better use a third party software "Find and Replace"
http://www.rickworld.com/download.html
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<no points please>

+1 for Find and Replace. It is invaluable for Access development work.
0
 
cquinnCommented:
There is also MZTools, which has many other useful functions

http://www.mztools.com/v3/mztools3.aspx
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
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.
0
 
cquinnCommented:
In that case - there is Total Deep Search in V-Tools

http://www.skrol29.com/us/vtools.php
0
 
Helen FeddemaCommented:
I agree.  I have been using FAR since the early days of Access, and it is an invaluable tool.  
0
 
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,

peter
0
 
PeborghAuthor Commented:
Got Vtools, used it for bulk replace and all is well.
useful tool!
0
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now