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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Renaming field

Status
Not open for further replies.

tybeeisl

Instructor
Nov 22, 2002
5
US
When you rename a field in a table, is there an easy way to also rename it in all the expressions that refer to the field?

Many thanks,
Beth

 
Only way I know is Search And Replace... in the code this procedure works fine. In access2k and onwards fields refrences and query refrences are changed/renamed with the rename of the field.

Herman
 
Beth,
I use the Find & Replace Access add-in by Rick Fisher. Inexpensive ($37) and works great! I recently used this on a database with over 350 fields, this saved me a ton of time. His website is BTW, it's free for the first 30 days.
Ed
 
F & R is a great product. I would recommend turning off the name tracking in a2k and onwards, as it gums up performance a decent bit.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks
Professional Development for Clients Large and Small

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top