Creating a reminder

[THEAF]

hi,
I'm trying to create a reminder. i have 2 forms one for to set the reminder and one to view all the reminders. these reminders are recorded on access. i can save the reminder and the other form shows the reminders, but it does not alert the user at the time the reminder is set unless your on the form that shows all the reminders. i just used if rs!(record set)time = time and re!date = date then show msgbox. im thinkin that t might be a global thing but i don't know how to code it like that. if anyone has done anything like this then can you please help me.
Thank YoU

[VBWheaties]

hi,
I'm trying to create a reminder. i have 2 forms one for to set the reminder and one to view all the reminders. these reminders are recorded on access. i can save the reminder and the other form shows the reminders, but it does not alert the user at the time the reminder is set unless your on the form that shows all the reminders. i just used if rs!(record set)time = time and re!date = date then show msgbox. im thinkin that t might be a global thing but i don't know how to code it like that. if anyone has done anything like this then can you please help me.
Thank YoU

Use a timer control to handle the background work. Make sure you hide your form instead of unloading it since the form is what will keep the program in memory (at least, in VB 6 which is what I am assuming you are using).
In the timer event, check your database for what you need then load and show your reminder as needed.

[debasisdas]

You need to run your code in a timer event.
Better to run the application in the system tray.