changing field names

[Guest]

If I change a field name in my tables, is there an easy way to have it
updated in all of my querries, forms, and reports? I used the field names
"date" and "time" prior to knowing better and would like to change them in
the main tables and have the new names make their way through the many layers
of my querries and forms and reports so that I don't have to go into every
object and change them by hand.

 

[Guest]

If you have Access 2002 or later look under TOOLS - Options - Genaral - Name
AutoCorrect.

About using Name AutoCorrect to fix errors caused by renaming
In Microsoft Access 97 and previous versions, if you rename a field in a
table, the objects based on that field no longer display the data from that
field. Access 2002 automatically corrects common side effects that occur when
you rename forms, reports, tables, queries, fields, text boxes or other
controls in a Microsoft Access database. This feature is called Name
AutoCorrect.

Whenever you open a form or other object, Access automatically looks for and
fixes discrepancies between the form and the other objects that the form
depends on. For example, if you open a form that is bound to a table, Access
compares the date/time stamps for the table and the form. If they are
different, Access performs a Name AutoCorrect.

In order to take advantage of the Name AutoCorrect feature, you must be able
to save changes to the form, report, or other object that Name AutoCorrect is
fixing. You can save changes to an object if you have permissions to modify
the design of the object, if you have write access to the database, and if
you have exclusive access to make changes. If you can't save the object, the
fixes are not saved when you close the object. Name AutoCorrect makes the
changes each time that the object is opened but can't save the changes until
someone with permissions to modify the design opens and saves the object.

 

[Douglas J. Steele]

Consider using a third party product:

Find & Replace: http://www.rickworld.com/products.html
Speed Ferret: http://www.moshannon.com/speedferret.html
Ucora's: http://www3.bc.sympatico.ca/starthere/findandreplace/