Hi,
I am currently working on an access database (2003 format) and need to have access set a reminder based on a date from a database record. This would be in an exchange environment.
I was thinking that if I set the update property on the form to auto create an outlook task with a reminder or better an appointment in a shared calendar with reminders (is this possible?). I found this code snipplet but I keep getting an undefined sub error.
Any help?
I did reference to outlook 11.0 objects under tools/reference.
What I am really curious about is in the case of a shared database - how do you handle which outlook is used to generate the objects (tasks, reminders, email)?? In this situation I have say 5 users using identical machines with identical software and nobody knows who will be accessing the form at any given time, yet I want to reminders to go to a "coordinator" is this possible?
I am currently working on an access database (2003 format) and need to have access set a reminder based on a date from a database record. This would be in an exchange environment.
I was thinking that if I set the update property on the form to auto create an outlook task with a reminder or better an appointment in a shared calendar with reminders (is this possible?). I found this code snipplet but I keep getting an undefined sub error.
Any help?
Code:
Function fncAddOutlookTask()
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
With OutlookTask
.Subject = "This is the subject of my task"
.Body = "This is the body of my task."
.ReminderSet = True
'Remind 2 minutes from now.
.ReminderTime = DateAdd("n", 2, Now)
'Due 5 minutes from now.
.DueDate = DateAdd("n", 5, Now)
.ReminderPlaySound = True
'Modify path.
.ReminderSoundFile = "C:\WINNT\Media\Ding.wav"
.Save
End With
End Function
I did reference to outlook 11.0 objects under tools/reference.
What I am really curious about is in the case of a shared database - how do you handle which outlook is used to generate the objects (tasks, reminders, email)?? In this situation I have say 5 users using identical machines with identical software and nobody knows who will be accessing the form at any given time, yet I want to reminders to go to a "coordinator" is this possible?