Solved

ms access find and replace software for free.

Posted on 2009-04-06
3
260 Views
Last Modified: 2013-11-29
I want to find to content in selected cols in an access db and replace with other text.
0
Comment
Question by:ColinSRule
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 24080963
For all practical purposes, this is free:

http://www.rickworld.com/products.html#Find%20and%20Replace%209.0

I've been using F&R for 15 years 24x7x365 ...the best there is.

mx
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 24082179
Access has some built-in Find features, but they're not nearly as robust as the one mx pointed you to. Or you can build your own utility that does this ... it's pretty easy to build UPDATE statements that will do this for you, but if you have advanced needs (like you want to replace whole words only, or only replace the word "easy" if the field also contains the word "free") then you'll be much, much further ahead of the game if you bite the bullet and spend the $35 for F&R.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

730 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