Recording Changes made in a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am designing a Database, and managed to do mostly everything I needed to do.

However, I can't seem to find any examples or ideas on HOW to record any
changes made in a form in another separate table, which has the same fields
as the form I want to record the changes. I tried using Before Update Event,
but instead of saving the information into a NEW RECORD every time a record
is changed, it just overwrites the existing table record.

To Summaries I want all changes made in a form to be saved in a separate
table, for instance if price is changed from £10 to £7 to £2 - I want all
these changes saved in a separate table to keep track of everything that
happens.

Can anyone help?

Thanks in advance,
Cowji
 
Cowji,
When you edit data on your form, your only changing the data in the table
the form is based against.
Basically, you'll need to use the AfterUpdate event for each field you
want to track. When the user updates a field, you'll have to run an Append
query against the other table (ex. tblDataChanges), where you would Append
information such as Time, Date, CurrentUser, FieldName, FieldValue.

hth
Al Camp
 
Cowji said:
Hi,

I am designing a Database, and managed to do mostly
everything I
needed to do.

However, I can't seem to find any examples or ideas on HOW
to record
any changes made in a form in another separate table,
which has the
same fields as the form I want to record the changes. I
tried using
Before Update Event, but instead of saving the information
into a NEW
RECORD every time a record is changed, it just overwrites
the
existing table record.

To Summaries I want all changes made in a form to be saved
in a
separate table, for instance if price is changed from £10
to £7 to £2
- I want all these changes saved in a separate table to
keep track of
everything that happens.

Can anyone help?

Thanks in advance,
Cowji
Click to expand...

This from Allen Browne's site should get you started;

http://members.iinet.net.au/~allenbrowne/AppAudit.html

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
Back
Top