Notification

K

ktfrubel

How do we create a notification on a table/form if an entry was made in a
journal. This is what we want to do.

We have created a database that will be used by multiple users. Whenever a
note is made in the journal form, we would like for a color or a check box or
a note to appear on the origial table and or form. How can this be done?
My boss Jill, who is more versed in Access than I am will be doing the
follow up correspondence.


Thanks
Tara
 
A

Arvin Meyer [MVP]

A color can only be done through conditional formatting which must rely on
the data from a boolean control (check box) to work. Unfortunately, a check
box only will show what happened the first time it is used unless it is
cleared at the end of each session. Therefore the best solution is to
timestamp each record after it has been updated. If it hasn't been updated,
there will be an empty textbox, otherwise the text box will contain the date
and time of the last update. So:

1. Add a field to the table of type date/time (or a yes/no field if you
really want a check box).

2. Add a textbox to your form (or a checkbox)

3. Add the following code to your form:

Sub Form_AfterUpdate()

' Me.chkUpdated = True ' for a checkbox
Me.txtLastUpdated = Format(Now, "m/d/yy hh:nn")

End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top