Determine if a table has changed/updated

[Guest]

Hello all,

I need to be determine programatically in a macro or a module if a
table has changed, I.E a new record has been added. When that
happens, an email needs to be sent. I found code on the internet to
send the email but I can't seem ti find anything on how to determine
if a new record has been added.

Any help or direction would be greatly appreciated.


Regards
Dale Jones

 

[tina]

if you mean when a user is manually adding a new record to a table, then the
user should be doing so via a form, not directly into the table. at the form
level, you can check the NewRecord property to identify a new record, and go
from there.

hth

 

[Guest]

Thanx for responding Tina. NewRecord may be a way to attack my
problem. The problem is, I'm just savvy enough at programming to be
dangerous.

Another question tho.

Actually for a little additional explanation, InfoPath will be adding
the record. I thought we could use that app as an automated employee
time-off request. When the employee filled out the request in
InfoPath, it would add a record to an access database.

At that point, Access would determine a new record had been addded and
fire off an email to the supervisor (among other things)

So then I'm wondering how to determine which record is the new one?
The one that just got added?

Regards
Dale

 

[tina]

well, working with other software in conjunction with Access has to be one
of my weakest areas in programming - and i know absolutely nothing about
InfoPath. my only thought would be that if you're manipulating Access
programmatically from within InfoPath, that you try manipulating your email
software at that same point - either by manipulating it from InfoPath, or
from "inside" the Access manipulation. what i'm getting at is that if you
already have code running where InfoPath creates an Access record, so that
would be the logical point to generate an email, rather than trying to make
Access recognize that a record was added programmatically to one of its'
tables, and *then* generating an email at that point.

if the above doesn't give you any ideas, or at least a direction to go,
suggest you wait a day to see if anyone else picks up this thread, and if
not, then repost - making sure you include the details about InfoPath, so
you can get a better response.

hth