Alerts

[Jasper Recto]

Is it possible to have email alerts or pop up messages from a Access
database?

I have a user that keeps track of our machine maintenance in excel. They
need to be able to get some sort of alert that informs them that a specific
machine needs preventive maintenance. It would just be triggered of an
existing date field.

Is this possible?

Thanks,
Jasper

 

[Jeff Boyce]

Jasper

One approach to doing this from within Access would be to build the query
that returns the records you need, then use a Timer event in a form to
trigger the running/display of the query/results. Of course, your copy of
the Access database would need to be open for this to work.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Damon Heron]

here is a simple way to send an email message with a command button - you
would need to fill the variable txtStr with your date, etc. If you want an
automatic msg, then the code could be triggered by some other event.

Private Sub Command8_Click()
Dim txtStr As String
txtStr = "Test of main body of email"
DoCmd.SendObject acSendNoObject, , , "Damon Heron", , , "Scheduled
Maintenence", txtStr, False
End Sub

Damon