M
Mike375
Guest
I have just about cleaned up my data case, lots of field removals, streamlining of macros and code, removal of redundant tables, queries etc. But I have one last part to go and that concerns field names with two words like First Name, Last Name etc. (as a side note these names are there because I originally used an insurance company quote/policy managemnt system as my starting point back in 1995
) I figure the bloke in the insurance company who made their system was too young to have been on DOS where LastName etc was standard.
Fortunately I don't have too may of them as most of the fields I did myself
When I deleted fields from the the tables I just went to the queries and deleted all the fields that were like Expr63 etc.
But for changing the field names I just tried "Track name AutoCorrect info" but the were results were very inconsistent. In some queries all the new names were there but with others there were no changes. I am wondering if I did I wrong or it is not a good tool and I am better off it to do it manually.
On a side note I assume I could code with Find and Replace. Macros...well that is a manual exercise

Fortunately I don't have too may of them as most of the fields I did myself

When I deleted fields from the the tables I just went to the queries and deleted all the fields that were like Expr63 etc.
But for changing the field names I just tried "Track name AutoCorrect info" but the were results were very inconsistent. In some queries all the new names were there but with others there were no changes. I am wondering if I did I wrong or it is not a good tool and I am better off it to do it manually.
On a side note I assume I could code with Find and Replace. Macros...well that is a manual exercise
