I'm working with a fairly large DB and the engineers have decided to come up with a new naming convention for a column called FailType. I don't think I'll have a problem updating the old fail types to the new ones, but my concern is finding where a particular fail type was used in a query's 'where' clause. There are many queries and reports that have this value ... Is there a way I can change these field values throughout the entire db? Sigh ...
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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Updating values in a field and
- Thread starter kangj
- Start date
Use the "Find and Replace" menu option in any VBA Code module. This gives you the option of searching/replacing in the Current Procedure, the current Module or the current Database.
Open any module, then click EDIT|FIND (or the binoculars icon on the toolbar).
HTH
Lightning
Open any module, then click EDIT|FIND (or the binoculars icon on the toolbar).
HTH
Lightning
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question