Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Global Find and Replace

Status
Not open for further replies.

Tjohn1975

Programmer
Oct 8, 2001
3
AU
Hi their

I am looking for a global find and Replace for Microsoft Access databases, I am aware of FMS and ReplaceWiz , but I am looking for a free utility, dose any one know of any out their

Regards,

Tjohn

 
Are you referring to searching the code on a find & replace basis, or the actual records in the db? James Goodman
j.goodman00@btinternet.com
 
The actual replacemnt of strings in Forms, reports, querys..etc, Also if possible the replacments of field values in Tables.

Thanks in advance
 
find & replace of code is simple. Just use the replace (edit-replace) tool from the main access menu. This will allow you to search for strings within a procedure, module or entire database, & then replace them with something else. This can also be done for fields in the database if you know which fields need updating & they aren't too numerous. However, if they are numerous it would take forever.... James Goodman
j.goodman00@btinternet.com
 
Yeah it does work great when working with code. But it is not so good if I am changing label names or maybe I just want to know every form that uses a certain field.
 
Speed ferret and ReplaceWiz will do just that ,i.e: they will replace label names and control names in forms and reports ,but they are not freeware , do you guys know of any freeware out their
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top