Trigger for an action

[Guest]

Is there a way to set up a visual trigger that will pop up for a user based
on a specific date? For example, I have a contact database in Access 2002.
One of the fields in my form is a "Follow-up Date". I would love to be able
to create some sort of pop up window that would automatically come up if a
date in the the "Follow-Up" date field matches today's date. Is this
something that can be done? Any help is most welcome!

Thanks,
Lauren M

 

[Rodger]

Lauren,

You can use conditional formating (Format . . . .Conditional Formating) to
change the color of the field or you need to place some code on the
OnCurrent Event.

Dim myDate, myMessage, myTitle, myStyle, myResponse

myDate = me.txtYourFieldName
if myDate = Date() then 'use <= to include past dates
myMessage = "Follow up needed"
myStyle = vbOKOnly + vbCritical
myTitle = "Follow up"
myResponse = msgboc(myMessage, myStyle, myTitle)
end if

Hope that helps,
Rodger

 

[Guest]

Check the information her
http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us

I too am curious about this and would find it helpful in my project. Let me
know how it goes..