Changing field names

  • Thread starter Thread starter Emma
  • Start date Start date
E

Emma

Hi I have a database which I'm trying to clean up with appropriate names. It
is problematic for example I changes Intake Coordinator to Primary Worker and
Due Date to Closed Date etc... So the problem is that now the reports have
the new fields but the old fields are poping up . So I changed the field in
the report to Primary worker and when I run the report it askes me for Intake
Coordinator which it never did before. I know it has something to do with the
grouping and sort but I don't want to change that. Thanks Emma
 
If you have grouped and sorted on fields whose name you have changed, you
will have to change the grouping and sorting. You have no choice. I'd have
used the Find & Replace utility (by Rick Fisher, http://www.rickworld.com)
to make the change really, truly global. Auto Correct (often called Auto
Corrupt due to the troubles people have had with it) doesn't change "every
occurence of the text everywhere and offer you approval of each change". It
is not free, but it is not expensive. And, as far as I know, the other
principal competitor to Find & Replace, Speed Ferret, has not been updated
for the most recent versions of Access.

From your description of the problems you are encountering, I infer that you
are changing Field names in the Tables, not just Control names (some
mis-call those "fields") on the Reports.
 
Some versions have a feature called 'name autocorrect' that changes the name
every where it is used. If your does then you should rename to the old name,
turn on the feature and then rename to new.

If your does not, most have Analyze - Documentor. Select all queries, form,
and reports, save to Word, and search for the name.
 
Back
Top