Search

[tbeers]

I run Access 2007. I have decided to change the name of a table field....yeah I know but I used a key word "date" for one of the fields and now that I am doing some date math, it creates a very confused program. I am going to change the "date" field to "workdate". Is there a search and replace method that will search the complete program including queries, forms and reports.

Thanks

-Tomb

[ChipR]

You can search all the code if you open a module in the editor, Edit-> Find, and select Current Project on the left under Search.

You could use some code to step through each control on each form in your database and if the control name is Date, print out the form name.
You should be able to iterate through the tableDefs and queryDefs too.

Sorry I don't have code to do that at the moment. I know I'd get the syntax wrong if I tried, but you should be able to find it online.