Find out what fields have been changed

[Flick Olmsford]

I added some code to the after insert and after update events in a few forms
to my Access 2003 db. These use the INSERT INTO stmt and inserts records
into a table that record who added a record and when as well as who edited a
record and when. I simply created an append query, tested it, then copied
the SQL to a module in the forms and use the docmd.runsql strSQL

Is there an easy way to find out what fields have been modified so I can
include this in the recording down the line. I am sure my boss will ask for
this next.

Thanks

 

[Jerry Whittle]

Easy? Not in Access. You may need to upsize to a RDBMS that supports auditing
such and Oracle or (hoping not to sound like Aaron K) SQL Server.

 

[John W. Vinson]

I added some code to the after insert and after update events in a few forms
to my Access 2003 db. These use the INSERT INTO stmt and inserts records
into a table that record who added a record and when as well as who edited a
record and when. I simply created an append query, tested it, then copied
the SQL to a module in the forms and use the docmd.runsql strSQL

Is there an easy way to find out what fields have been modified so I can
include this in the recording down the line. I am sure my boss will ask for
this next.

Thanks

I'd have to agree with Jerry. This can be done but it's a real chore. You'll
need to compare the value in each data-bound control to its OldValue property
to see if it's changed (watch out for NULLs and deletions).