How do I tell if table contents have changed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Stroope - 25 Jan 2008 00:16 GMT

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.

Signature

Thanks,

Jeff

Reply to this Message

Tom van Stiphout - 25 Jan 2008 05:23 GMT

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.

>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
[quoted text clipped - 4 lines]
>with the LastUpdated property of the TableDef object but it didn't seem to
>suit my needs.

Reply to this Message

Jeff Stroope - 25 Jan 2008 17:58 GMT

Thanks Tom - does a table have an after update event?

Signature

Thanks,

Jeff

> 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
[quoted text clipped - 10 lines]
> >with the LastUpdated property of the TableDef object but it didn't seem to
> >suit my needs.

Reply to this Message

Douglas J. Steele - 25 Jan 2008 22:44 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Thanks Tom - does a table have an after update event?
>
[quoted text clipped - 18 lines]
>> >to
>> >suit my needs.

Reply to this Message

Keith Wilby - 25 Jan 2008 08:49 GMT

> Hi - in my database I need to send a notification email if the contents of
> a
[quoted text clipped - 7 lines]
> 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

Reply to this Message

Jeff Stroope - 25 Jan 2008 18:00 GMT

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

Signature

Thanks,

Jeff

> > Hi - in my database I need to send a notification email if the contents of
> > a
[quoted text clipped - 17 lines]
> Keith.
> www.keithwilby.com

Reply to this Message

Keith Wilby - 28 Jan 2008 08:41 GMT

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

Reply to this Message

Jeff Stroope - 28 Jan 2008 17:16 GMT

Good point!

Signature

Thanks,

Jeff

> > Thanks Keith - I actually have a history table, but they just want to be
> > notified and sent a spreadsheet with the changes.
[quoted text clipped - 3 lines]
>
> Keith.

Reply to this Message