How do I tell if table contents have changed?

  • Thread starter Thread starter Jeff Stroope
  • Start date Start date
J

Jeff Stroope

Hi - in my database I need to send a notification email if the contents of a
particular table have changed. The problem is, sometimes the user changes
his mind and undoes his edits. In that case, I don't want to send the email
because it will be just a false alarm. Is there an easy way to check a table
when the user exits the databse to see if its contents have changed from
their values at the beginning of the user's session? I was playing around
with the LastUpdated property of the TableDef object but it didn't seem to
suit my needs.
 
On Thu, 24 Jan 2008 16:16:06 -0800, Jeff Stroope

I am assuming that table is updated using some form. In the
Form_AfterUpdate you can write your code: at that time the edits have
been committed to the db and it's too late to undo.

-Tom.
 
Jeff Stroope said:
Hi - in my database I need to send a notification email if the contents of
a
particular table have changed. The problem is, sometimes the user changes
his mind and undoes his edits. In that case, I don't want to send the
email
because it will be just a false alarm. Is there an easy way to check a
table
when the user exits the databse to see if its contents have changed from
their values at the beginning of the user's session? I was playing around
with the LastUpdated property of the TableDef object but it didn't seem to
suit my needs.
Click to expand...

Hi Jeff,

Sounds messy to me. How about recording each edit to a history table and
give your e-mail recipients access to it? That way only "real" edits get
recorded and all your users need to do is check for changes. I have some
code that will do this if you want it.

Keith.
www.keithwilby.com
 
Thanks Keith - I actually have a history table, but they just want to be
notified and sent a spreadsheet with the changes.
 
No, tables have no events, but then you should never be working directly
with the table.
 
Jeff Stroope said:
Thanks Keith - I actually have a history table, but they just want to be
notified and sent a spreadsheet with the changes.
Click to expand...

Not being funny but that doesn't make sense. How does the user undo edits
in a history table?

Keith.
 
Back
Top