If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Changing field names
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 |
#3
|
|||
|
|||
Changing field names
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 |
Thread Tools | |
Display Modes | |
|
|