Solved

Bulk replace string in an Access 2007 app

Posted on 2011-02-21
8
309 Views
Last Modified: 2012-05-11
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
Comment
Question by:Peborgh
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 34943895
better use a third party software "Find and Replace"
http://www.rickworld.com/download.html
0
 
LVL 84
ID: 34944032
<no points please>

+1 for Find and Replace. It is invaluable for Access development work.
0
 
LVL 15

Expert Comment

by:cquinn
ID: 34944126
There is also MZTools, which has many other useful functions

http://www.mztools.com/v3/mztools3.aspx
0
 
LVL 84
ID: 34944211
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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 15

Accepted Solution

by:
cquinn earned 500 total points
ID: 34944261
In that case - there is Total Deep Search in V-Tools

http://www.skrol29.com/us/vtools.php
0
 
LVL 31

Expert Comment

by:Helen_Feddema
ID: 34944262
I agree.  I have been using FAR since the early days of Access, and it is an invaluable tool.  
0
 

Author Comment

by:Peborgh
ID: 34950212
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
 

Author Closing Comment

by:Peborgh
ID: 35009042
Got Vtools, used it for bulk replace and all is well.
useful tool!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now