UtterAccess.com
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
Post#1



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
 
theDBguy
post May 17 2017, 10:38 AM
Post#2


Access Wiki and Forums Moderator
Posts: 69,684
Joined: 19-June 07
From: SunnySandyEggo


Hi,

Welcome to UtterAccess!
welcome2UA.gif

Maybe you could try using this instead...

.RecurrenceType = 5

...just to see if it makes any difference.

--------------------
Go to the top of the page
 
DanielPineault
post May 17 2017, 11:21 AM
Post#3


UtterAccess VIP
Posts: 4,889
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.

--------------------
Daniel Pineault (2010-2016 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    27th May 2017 - 02:55 AM