Changing field names
in [General]
|
Prev: Final Reminder - Microsoft Responds to the Evolution of Community
Next: List of values summing to a known value
From: Emma on 28 May 2010 14:56 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
From: Larry Linson on 28 May 2010 15:28 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" <Emma(a)discussions.microsoft.com> wrote in message news:85389EAD-30DF-415A-8260-8D00A264F8C0(a)microsoft.com... > 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
From: KARL DEWEY on 28 May 2010 16:15
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 |