Global Replacing of string of characters

Topic

New Reply

This is probably very dangerous if it exists, but I have inherited a database with several reports where a designated level of hierarchy is “hard coded” into the queries as selection criteria and other places. Is there a way to replace all occurences of a string (e.g. “Region”) with a replacement string (“Division”) in all queries, reports, forms and in the VBA code at one time?

Thanks for your ideas.

Ken

Reply | Quote

Replies

Download and install the utility Find and Replace for Microsoft Access from Rick Fisher.
It’s not free, but you can try it out without cost for thirty days. This utility is well worth its modest price, by the way.

Find and Replace lets you replace all occurrences of a string throughout the database.

Reply | Quote

Thanks, I’ll give it a try.

Download and install the utility Find and Replace for Microsoft Access from Rick Fisher.
It’s not free, but you can try it out without cost for thirty days. This utility is well worth its modest price, by the way.

Find and Replace lets you replace all occurrences of a string throughout the database.

Reply | Quote

“Find and Replace” is my utility of choice also. “Speed Ferret” is another similiar utility; it has a good reputation (I’ve never used it personally), but it is more expensive.

Reply | Quote

Appologies for gate crashing on the post, but what does the third party search and find software do that the normal Access find and replace wont’t do? Thanks

Reply | Quote

Access 2000 and later have a Name AutoCorrect feature but it’s known to cause many problems: it slows down Access considerably, it makes reports lose their page settings and it isn’t very reliable either. So it’s best to turn it off.

The Visual Basic Editor has an excellent replace feature that can work across the entire database, but it is limited to VBA code, it doesn’t affect the design of database objects.

The Find and Replace add-in lets you search for and replace any string of text in the design of tables, queries, forms, reports, macros, pages *and* in VBA code. You can specify precisely which objects to include. So it’s much more powerful.
The paid version has some additional features such as a cross-reference tool that shows where database objects are used.

Reply | Quote