Access Alarm

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am looking to find a way to place an alarm on an access
database to notify me of the reorder levels once a
product reaches a specific number.

Any help appreciated.....
 
John said:
I am looking to find a way to place an alarm on an access
database to notify me of the reorder levels once a
product reaches a specific number.
Click to expand...

Access does not support Triggers, so you'll have to run your code from a
form. You can, for instance, run a query when the form opens to see if the
inventory is below the reorder level. Or you can leave the form open
(hidden, if you prefer) and use the Timer event of the form to run the
query.

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
One thought - assuming there are others using the
database and you can create a module that is called when
inventory is updated or when the form/database is
opened/closed. In essence: have the module to identify
those inventory items (maybe a make table query). Then
email the table or report with the sendobject command.

This email could be just a message or it can have a table
or report attached.

I have used this to email error messages back to myself in
certain situations and also in regular production to email
reports (RTF format) to internal /external customers.

HTH
SteveD
 
Back
Top