How do I tell if table contents have changed?

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.
 
T

Tom van Stiphout

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.
 
K

Keith Wilby

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.

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
 
J

Jeff Stroope

Thanks Keith - I actually have a history table, but they just want to be
notified and sent a spreadsheet with the changes.
 
D

Douglas J. Steele

No, tables have no events, but then you should never be working directly
with the table.
 
K

Keith Wilby

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.

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

Keith.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top