Hello friends,
I am having a bit of problem in trying to create an append query to store data from unbound textboxes to a table. I know that it's not the correct way to manage my db and will give you some quick info.
Once a week I get a txt file which I import in my table "Clients". During the week, data can change and want to store in a different table named "History" which gives me an historical record of all the new data. Obviously the following week, data in "clients" is update and this explains the reason of having an historical log.
I would like to append the new data that users will add in Tab New Data of form Clients to the table History, taking the FileNo as criteria. Once saved, the new data unbound textboxes, should be null ready for other data to be entered.
For your convenience, I have attached a simple examples db.
Thank you for any help.
I am having a bit of problem in trying to create an append query to store data from unbound textboxes to a table. I know that it's not the correct way to manage my db and will give you some quick info.
Once a week I get a txt file which I import in my table "Clients". During the week, data can change and want to store in a different table named "History" which gives me an historical record of all the new data. Obviously the following week, data in "clients" is update and this explains the reason of having an historical log.
I would like to append the new data that users will add in Tab New Data of form Clients to the table History, taking the FileNo as criteria. Once saved, the new data unbound textboxes, should be null ready for other data to be entered.
For your convenience, I have attached a simple examples db.
Thank you for any help.