[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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