I want to see Data Base alert when some body insert new record

[Guest]

Dear I have Request system by Access so i need when the user insert new
record i want alert box or message
To tell me that i get new request
Note: i used ( Net send ) function but it is not practical way so i want
when i opend the database
and any user insert new record i want to get alert for that or
message.

Thanks to ur help

 

[Madhivanan]

I think you can insert a field of datetime in all the tables. In the
user table set the logout datetime. When the user opens the application
search in the tables whether there are records which have higher
datetime of the datetime field of user table. If so, populate them.

Madhivanan

 

[Douglas J. Steele]

What you want could be provided by a trigger, but Access doesn't support
triggers. The approach outlined by Madhivanan (to provide a date field and
query on that field on a periodic basis) is the only possibility.

 

[Nick Coe \(UK\)]

Hi Tony,

I've rebuilt my web site, would you mind updating your link
next time you're updating yours? I'm messaging you here
'cause I think your email spam trap's getting me...

Cheers

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/ Download Free Demo Copy

In Tony Toews typed: