By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Search

P: 64
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
Jan 29 '09 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 1,287
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.
Jan 29 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.