What kind of new record notification? If you mean can your code check to see
if the record already exists, the answer is "yes"
Use DLookup or a recordset to look for the existance in the BeforeUpdate
event of a text box or the form itself.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
I have a Help Desk database, I would like to receive a popup on my monitor
whenever a user enter an entry. I been trying to use Net Send command to my
IP address using the Shell function, I've had no luck yet. We have several
machine running Windows 98, I don't think Net Send works with that OS.
Simple enough, but not as efficient as if you had a server based database
which supported Triggers. On my website, I have a sample that demonstrats
using a form to poll a table for data. You can adapt it to store a timestamp
in memory or a public variable, then send an email, or popup a form, or
message box, if a newer record is added.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
