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

Jeff

On Thu, 24 Jan 2008 16:16:06 -0800, Jeff Stroope
<(E-Mail Removed)> wrote:

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

"Jeff Stroope" <(E-Mail Removed)> wrote in message
news:976588CB-E1F5-4DC6-AA0C-(E-Mail Removed)...
> 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

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

Jeff


"Tom van Stiphout" wrote:

> On Thu, 24 Jan 2008 16:16:06 -0800, Jeff Stroope
> <(E-Mail Removed)> wrote:
>
> 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
> >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.
>

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

Jeff


"Keith Wilby" wrote:

> "Jeff Stroope" <(E-Mail Removed)> wrote in message
> news:976588CB-E1F5-4DC6-AA0C-(E-Mail Removed)...
> > 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
>
>

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

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


"Jeff Stroope" <(E-Mail Removed)> wrote in message
news:77ECA89B-92F0-45F4-97C1-(E-Mail Removed)...
> Thanks Tom - does a table have an after update event?
> --
> Thanks,
>
> Jeff
>
>
> "Tom van Stiphout" wrote:
>
>> On Thu, 24 Jan 2008 16:16:06 -0800, Jeff Stroope
>> <(E-Mail Removed)> wrote:
>>
>> 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
>> >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.
>>

"Jeff Stroope" <(E-Mail Removed)> wrote in message
news:9B789817-10F2-406E-9926-(E-Mail Removed)...
> 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.

Good point!
--
Thanks,

Jeff


"Keith Wilby" wrote:

> "Jeff Stroope" <(E-Mail Removed)> wrote in message
> news:9B789817-10F2-406E-9926-(E-Mail Removed)...
> > 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.
>
>