Notification

[Guest]

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?

 

[Jeff L]

You would use a MsgBox to pop up a message.

 

[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