Don't like field names.

[Kevin O'Connell]

I have an Access program that I want to re-use for another application/company. Very similar but using the same fields for different data.

Can I change the field names across the program automatically. i.e change AppleQTY to OrangeQTY in a table and have the relationship to all forms, reports and queries also change.

Kevin
Galway, Ireland

 

[Thecherub]

I don't think so

I have an Access program that I want to re-use for another application/company. Very similar but using the same fields for different data.

Can I change the field names across the program automatically. i.e change AppleQTY to OrangeQTY in a table and have the relationship to all forms, reports and queries also change.

Kevin
Galway, Ireland

I don't think there is a way to do this. At least the way i was taught you can't. I usualy end up recreating forms, querys and reports when my fields change.

I could be wrong, If anyone has an another answer that would help me as well.

 

[ghudson]

Search the net for a program called "Speed Ferret". It is the only way to do what you want. I have never used it but I have heard great things about it. It is not freeware.

 

[theprez]

One of the programmers I work with swears by Speed Ferret.

 

[Pat Hartman]

If you don't mind spending the money, Speed Ferret is the way to go. Otherwise, you can use the NameAutoCorrect feature built into A2K and newer to do queries (stored querydefs, NOT queries in code or embedded as recordsources), forms, and reports. NO code is changed. So, if you have VBA code that references the changed objects, you'll need to use change/replace to take care of that.

Before you entrust yourself to AutoCorrect, make a backup of your db and read the article in the MSDN library.
NameAutoCorrect