"Alarm" reminder popup form on time event

[jdttek]

I have a db that allows users to set followup dates and actions. They can open a "tickler" form that lists all actions and dates and filter by today, past due, future, etc. I would like to ad a feature that works kind of like an alarm function: ie, a popup form opens automtically to remind user of scheduled event based on user defined alarm time (triggered off of system time). Kind of like Outlook Flag and Alarm pop-up functions.
I assume this will require some sort of timer event that would go into table, look up alarm times and, if matched with Now(), wld open form. Any hints on how to at least get started with this.
Thanks
JDTTEK

 

[FancyPrairie]

Create a form whose Timer Interval is set to, say, 1 minute (60000 milliseconds). Then at startup, open the form with the visible property set to False (i.e. [/color blue]DoCmd.OpenForm "frmTimer", , , , , acHidden[/color]). In the OnTimer event, Open the table to see if the "alarm" should go off. If the alarm should go off, then either make the form visible (assuming the form contains the info you want displayed) or open another form that contains the info you want displayed.