In that case, I guess you will need to write your own utility to loop
through each of the collections such as AllForms and AllReports, open each
one in design view, and, and loop through all the Controls, testing the
ControlSource of each one and comparing to the RecordSource of the
form/report to identify the ones that have the same name as your old field
and came from the same table.
After that, you could loop through the Fields of the QueryDefs and do the
same thing.
The Search'n'Replace in VBA code window makes it feasible to do that without
having to code it.
Macros are more of a problem. You have to use the undocumented SaveAsText to
write them out to files, and then search the files.
If you are using Access 2003, there is set of dependency objects included,
but I have not found these practical. They depend on the very badly flawed
Name AutoCorrect data, so last time we tried these would not run to
completion.
Your other option is to buy a tool such as SpeedFerret from Black Moshannon
Systems at:
http://www.speedferret.com/
but I guess if you can't download anything you can't get that either.
