Solved

Bulk replace string in an Access 2007 app

Posted on 2011-02-21
8
307 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 Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 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

20 Experts available now in Live!

Get 1:1 Help Now