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

[jehad hindi]

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.

 

[Tony Toews]

Dear I have Request system by Access so i need when the user insert new
record i want alert box or message

You can do this when the user uses a form to enter data. But as
others have pointed out you'd have to use a different approach if they
are entering data directly into the tables. You can also use email
to send the message.

There are two separate concepts here. The first is to figure out
what changes are being made. The second being the best method of
sending the emails.

1) There's a simple example at
ACC2000: How to Create an Audit Trail of Record Changes in a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197592

Audit Trail - Log changes at the record level at:
http://members.iinet.net.au/~allenbrowne/AppAudit.html
The article addresses edits, inserts, and deletes for a form and
subform.

Modules: Maintain a history of changes
http://www.mvps.org/access/modules/mdl0021.htm
The History Table routine is designed to write history records that
track the changes made to fields in one or more tables.

2) Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[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: