Etxezarreta
Member
- Local time
- Today, 11:02
- Joined
- Apr 13, 2020
- Messages
- 175
Hello everybody,
In order to allow the user to check, modify and also to prevent bad consequences of an error, I often create an empty copy of the table I want to populate with a form.
Then I create an INSERT TO query with VBA and sql code that inserts the data form the intermediate table into the final table, and then I delete all the date in the intermediate.
It works fine, but when I need to modify the structure of the tables, I need to change both table structures and code.
I would like to know how expercienced Acces user manage it: do you work directly in the final tables, or do you use different ways?
Many thanks in advance.
Etxe
In order to allow the user to check, modify and also to prevent bad consequences of an error, I often create an empty copy of the table I want to populate with a form.
Then I create an INSERT TO query with VBA and sql code that inserts the data form the intermediate table into the final table, and then I delete all the date in the intermediate.
It works fine, but when I need to modify the structure of the tables, I need to change both table structures and code.
I would like to know how expercienced Acces user manage it: do you work directly in the final tables, or do you use different ways?
Many thanks in advance.
Etxe