Pop up reminders

[chrisguk]

Hi all,

I need a solution to set a popup reminder when the database starts.

My logic is that someone sets a reminder date in another form and when that date and time comes a popup reminds them. I have seen examples of where the reminder is placed in Microsoft Outlook but cannot seem to get it to work.

Is there anyone that can help with this?

 

[John Big Booty]

Assuming that the reminder dates are store in your DB, why not simply use the On Load event of you welcome form to test Date() and then Pop Up your reminder message(s) based on the result of that test?

 

[chrisguk]

Assuming that the reminder dates are store in your DB, why not simply use the On Load event of you welcome form to test Date() and then Pop Up your reminder message(s) based on the result of that test?

I have to say I am not familiar with that method. Are u able to post an example?

 

[John Big Booty]

Here's one way you might do it, using the On Load event;

        If DCount("TaskDueDate", "TBL_Tasks", "TaskDueDate = #" & Date & "#") > 0 Then
            MsgBox "There are " & DCount("TaskDueDate", "TBL_Tasks", "TaskDueDate = #" & Date & "#") & " task due Today", vbOKOnly, "Task Reminder"
        ElseIf DCount("TaskDueDate", "TBL_Tasks", "TaskDueDate = #" & Date & "#") = 0 Then
            MsgBox "There are no Tasks due today", vbOKOnly, "No Due Tasks"
        End If