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.