change multiple control source names in multiple forms

[kuanli]

The problem occurred after I changed all the field names of the underlying tables of the forms. I have about 30 databases. Each has a table and a form and they are identical. How can I use some kind of code to change all the form controls so that they are linked to the changed table fields? Any hint is much appreciated.

Kuan

 

[gusbrunston]

Hi:
You "...have about 30 databases. Each has a table and a form and they are identical..." (!)
Since they are identical, just make your changes/corrections on one database and then make 29 copies of the database.
Or did I misunderstand? Gus Brunston An old PICKer, using Access2000. I manage

http://www.rentdex.com.

Suggestions welcome. padregus@attbi.com

 

[kuanli]

The design of the tables and forms are the same but they hold differrent data. Basically, there is one database for each employee.

 

[gusbrunston]

Hi:
I guess if you want a complete database for each employee, then it's your nickel.
You can still copy your database 29 times: you have a choice to copy "structure and data" or "structure" only. Simply choose "structure only". Gus Brunston An old PICKer, using Access2000. I manage

http://www.rentdex.com.

Suggestions welcome. padregus@attbi.com

 

[nberryman]

On each uses PC select Tools, Options

Click on the General Tab

Look at the Name Autocorrect options and select the options you want.

Make the changes to the field names and when the user next opens a form or report Access will detect the renaming error and resolve it.

Thats the theory anyway

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com