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: 71,237
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.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
post May 17 2017, 11:21 AM

UtterAccess VIP
Posts: 5,455
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-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 11:41 AM