Changing field names

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.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"Emma" wrote in message
...
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

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.

--
Build a little, test a little.


"Emma" wrote:

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