Access Reminder

[Rseven]

Can anyone tell me if there is a way to have a reminder pop up in Access? Sort of like when an appointment pops up in Outlook.

I created a contact form and enter the contact's information, etc. I also enter a call back time and was wondering if there was a way I could build some code that would make a msgbox pop up to remind me who I need to call, say within a half hour of the call being due.

Thanks in advance and any help is appreciated

 

[Remou]

Options include:

* Adding appointments to Outlook programmatically
* Running a background form in Access, with a timer event that scans for appointments.

 

[Rseven]

Thanks, I'd like to stay in Access if possible, any advice on the background form and the timer option?

 

[Remou]

Remember that the Timer Interval runs in thousanths of a second. You can use a hidden form. You can use SQL to check your table, for example:

[tt]strSQL = "Select ApptTime, AptLocation From Appointments " _
& "Where ApptCompleteFlag = False And ApptTime < #" _
& DateAdd("n", 30, Now) & "#"[/tt]

Appointments can be returned to a listbox on the form and the form made visible, or the SQL can be used as a RecordSource for another form.

 

[Rseven]

Thank you, will give it a try