Solved

ms access find and replace software for free.

Posted on 2009-04-06
3
255 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
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
Comment Utility
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
Comment Utility
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

771 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