"Track name AutoCorrect info"...changing field names?

[Mike375]

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

 

[pbaldy]

I don't know of anyone who has good things to say about that feature. Try this free utility:

http://www.skrol29.com/dev/en_vtools.htm

It should find names anywhere, even in VBA code.

 

[boblarson]

I don't know of anyone who has good things to say about that feature. Try this free utility:

http://www.skrol29.com/dev/en_vtools.htm

It should find names anywhere, even in VBA code.

Yep, that's the one I use. I love the Total Deep Search tool, which can replace as well as find. I turn off AutoName Correct and AutoName Correct Track.

 

[Mike375]

I don't know of anyone who has good things to say about that feature. Try this free utility:

http://www.skrol29.com/dev/en_vtools.htm

It should find names anywhere, even in VBA code.

Thanks for that. Now I won't waste time trying to make the "Track name AutoCorrect info" work.

 

[Mike375]

I don't know of anyone who has good things to say about that feature. Try this free utility:

http://www.skrol29.com/dev/en_vtools.htm

It should find names anywhere, even in VBA code.

Paul, that tool works like a charm.

With tables it is much quicker to change the field names manually but that is real easy.

It flies through the queries and forms. Really save me some trouble and especially since a lot of my fields on forms are set at 0 dimension all round.

It does not do Replace with macros but finds which macros and action line. But macros are easy to do if you know which macros and unlike queries you ar enot dependent on other macros be fixed first. I will get someone else to do the macros

 

[pbaldy]

Macro? What's a macro?

Glad it worked for you.

 

[Mike375]

Paul,

Do you have any ideas why this might be happening. As a side note it went from 18mb to 24 mb with the changes I did manually but did not change much when I did them with your tool. When I used the tool I started again from scratch except I used the tables where I had manually changed the fields. When I used the tool I started a new db and imported the tables that had been changed but imported the queries, forms, macros and modules from another copy.

http://www.access-programmers.co.uk/forums/showthread.php?p=716239#post716239

 

[Mike375]

Using the tool to change the table names, queries etc in one go for each field resulted in no growth in the db size as opposed to first chaning the table field names manually.