D
Debra Farnham
Hello All
Windows 2k, Access 2k, Outlook 2k
Two questions, but first a little background:
I have created a form in Access where on the click event of a button, it
creates an outlook task. The code snippet is as follows:
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
With OutlookTask
.Subject = "Review Needs for " & txtTopic & " Training"
.ReminderSet = True
.ReminderTime = #9:00:00 AM#
.DueDate = dtmReminderDate
.Save
End With
I am stuck on how to create the task as a recurring task that will recur at
the same time interval as dtmReminderDate.
dtmReminderDate is determined by the value in a combobox and a select case
that ultimately returns a date value that is one year from today's date
(DateAdd("yyyy", 1, Now) or two years from today's date, etc. etc. (I'm
thinking if I can get help with one I can probably figure out the others).
Question #2
How can I generate the same task on another user's task list when that other
individual has provided me with permission to do so.
Thank you in advance for any assistance.
Debra
Windows 2k, Access 2k, Outlook 2k
Two questions, but first a little background:
I have created a form in Access where on the click event of a button, it
creates an outlook task. The code snippet is as follows:
Dim OutlookApp As Outlook.Application
Dim OutlookTask As Outlook.TaskItem
Set OutlookApp = CreateObject("Outlook.Application")
Set OutlookTask = OutlookApp.CreateItem(olTaskItem)
With OutlookTask
.Subject = "Review Needs for " & txtTopic & " Training"
.ReminderSet = True
.ReminderTime = #9:00:00 AM#
.DueDate = dtmReminderDate
.Save
End With
I am stuck on how to create the task as a recurring task that will recur at
the same time interval as dtmReminderDate.
dtmReminderDate is determined by the value in a combobox and a select case
that ultimately returns a date value that is one year from today's date
(DateAdd("yyyy", 1, Now) or two years from today's date, etc. etc. (I'm
thinking if I can get help with one I can probably figure out the others).
Question #2
How can I generate the same task on another user's task list when that other
individual has provided me with permission to do so.
Thank you in advance for any assistance.
Debra