First note: This applicaiton is for A97 and A2000, I have also used it in A2003 ... So I selected 'All Versions', but unfortunately for A95 users, I do not have a version for you.

This is a utility that I use to find objects in my application that contain the string value you specify. This is useful when you want to change a field name in a table, but you need to to find out where you have used it first to see if it is worth changing the name or not. This utility is also good for determining if you can delete some old queries or tables you suspect you are not using any more, just type in the name of that query/table, select the object types you wish to search, then 'Search' ... the utility will point you to all occurrance of that string.

I search Queries, Forms, Reports, Tables, Modules, and Macros. The code behind forms and reports is also searched. I search Macros by first converting them to VBA the searching the VB that is generated by the conversion, the converted macro modules are deleted when the search is complete.

I realize that with A2000 and up has the 'Name AutoCorrect' feature, however, I personally do not use that feature for reasons mentioned on UA. This utility may not be perfect either, but it sure has been a lifesaver for me. I hope you find it useful as well.

The Zip file contains two .mdb files SearchForText_2000.mdb and SearchForText_97.mdb. Each .mdb file contains one form, xdlgSearchForText_35_<access version>. To use this utility just import the appropriate version into your application via the menu path File > Get External Data > Import, then navigate to the proper .mdb, select it, the select the form. All the code needed is behind the form. The forms use the DAO type library. The forms OnOpen event search for the DAO reference and trys to establish it if it is not found, if you have trouble with that portion of the code, just establish the DAO reference on your own, then disable the OnOpen event for the form.

Newer version has been posted here. The new version is for A2000 and up, but could be down converted to A97.