save oldvalues in new record

  • Thread starter Thread starter David
  • Start date Start date
D

David

I would like to create a new record in a table of log records, when any field
in a form in Access 2003 built with fields from multiple tables is updated.
This new record would be a snapshot of the fields used in the form and would
not necessarily need any relationship with any other table.
I have used the expression builder exclusively before and have little to no
experience with event proceedures and macros.
I want to capture the current date, DVR ID#(primary key), HD ID#(primary
key), Bus#(primary key), and Activity (text field) to create an ongoing
activity log.

I know you will not code this for me, but will you give me an idea of how to
accomplish this?
 
I hate to burst anyone's bubble, but building a audit trail isn't easy and
isn't going to be done using the Expression Builder! It is going to require
code and a fair amount of code at that. But a gentleman by the name of Allen
Browne has an excellent article that explains exactly how to do this:

http://allenbrowne.com/AppAudit.html
Click to expand...

That's one of the nice things about SQL Server... you can do it with
the INSERTED and DELETED tables... and it's free... One of the VERY
few times I actually agree with Aaron Kempf.
 
Thank you for your reply.
I DO understand "expression builder" cannot do this and further understand
code is probably necessary, but I do not understand the website you referred
me to. Basically I want to save four fields from a form to a new record on a
separate table. The website seems to be trying to accomplish far more
comprehensive logging.
 
Back
Top