Notification

A

asante_za

Does MS Acess support any form of notification? For example can I pop up a
message on the screen when a calculation in a query or a report reaches a
certain value?
 
G

Graham R Seach

Your problem isn't how to display the notification. As Jeff has indicated,
you can use a MsgBox for that.

Your problem is how to trigger the notification. Access isn't a server, so
there isn't an agent monitoring the tables. There are only two ways of
detecting such a condition in Access.

1. If the user enters, or causes the entry of data that meet the criteria,
from a form, then code on the form can display the MsgBox.

2. If an always-visible form constantly polls the table, and detects the
condition that will then display the MsgBox.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Top