Updating tables by VBA Code
I have a MIS program that works in four branches of our company. My program have two parts, database that include tables and another parts that include forms and other objects.
Updating the program is easy. I update the forms and reports in front-end program and save it as ACCDE file and distribute it between users, but sometimes I should amend, add or delete some fields in tables in back-end program and because the tables in different branches have different data I should do these amendments table by table and database by database. How I can write some VBA code that automate this task and can apply the update to tables in different databases by one code and process and in which procedure or function in VBA I should write these codes.
|
