X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Set reminder in Outlook calendar from Access form, Any Version    
The Wiz
post May 17 2017, 08:45 AM

Posts: 1
Joined: 12-April 17

Hi, folks...
I stumbled on this solution from 2007 and this gave me just what I was looking for. To add 2017 calendar appointments, I had to change the PatternStartDate and PatternEndDate to increase the date range (otherwise, it moved my 2017 appointments into 2003).
Instead of weekly recurrence though, I'm looking for annual/yearly recurrence for events such as tax day, renewal applications due, etc.
I changed the VBA code lines to:
" .RecurrenceType = olRecursYearly " ...
" 'Once per Year "
but that did not work. In the mean time, I can get the appointments in Outlook and edit the recurrence from there. Just an extra step I'd like to get rid of. Any suggestions? Thanks!
Go to the top of the page
post May 17 2017, 10:38 AM

Access Wiki and Forums Moderator
Posts: 73,458
Joined: 19-June 07
From: SunnySandyEggo


Welcome to UtterAccess!

Maybe you could try using this instead...

.RecurrenceType = 5

...just to see if it makes any difference.
Go to the top of the page
post May 17 2017, 11:21 AM

UtterAccess VIP
Posts: 6,119
Joined: 30-June 11

Are you using Early or Late binding?
Does your code compile without any errors?
Could you post your complete procedure?

If it can help you in any way feel free to review my procedure at https://www.devhut.net/2017/01/15/VBA-add-a...tlook-calendar/ but I do not have a reoccurance in it.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    16th October 2018 - 05:20 AM