Help Appending From Form!

[Access_help_rob]

Hey guys, well basically i have a form which runs off a table. the data in the table is basically records of times people have booked to a job. Usually through the form people would change hours booked to a job etc and it would change on the underlying table, i would like the changes to be recorded into a seperate table please can somebody help me
Thanks.
P.s there is already one sub form on the form which contains the the details of the hours and the main form contains the main information such as ID, worker name etc.

 

[neileg]

Not going to be easy. Jet (the database engine behind Access) does not track changes in the way that, say, Oracle does.

If you open your existing form in add mode, then your users wont be able to change the data once it is saved, so you can force users to use a different form for changes.

This changes form could be based on your existing data, and a subform to hold the change transactions. Not sure how you are going to handle these changes and associate the change transactions with the original data, though. Do you want to hold the original transaction and the net changes, or delete the original transaction and just hold the new one, or flag the original as 'out of date'? Why do you want the changes in a diferent table?

Are you sure this is what you want to do?

 

[Access_help_rob]

Hey, wot i need to do is to put the changes into a new table so i have a before and after. So ideally im thinking put all data in the subform to my new table then comapring them to show the changes in a query, however i cant get the data in the subform to append to a different table, please help
thanks
rob

 

[neileg]

Hey, wot i need to do is to put the changes into a new table so i have a before and after.

No, you've decided that this is the best way of achieving the before and after. It may not be the best way.

So ideally im thinking put all data in the subform to my new table then comapring them to show the changes in a query, however i cant get the data in the subform to append to a different table, please help

If the subform is bound to the new table then records will be saved in the new table.

By using a separate table, you will always need to see both tables to know what the current position is. I would prefer to either use one table, with a field in each record to show if it is current, or to transfer the superceded reords to another table as an archive. Using either of these approaches, the current records are all in one table.

 

[Rich]

you might find this article helpful
Article ID: Q103269