The Recurrence form in MSOutlook contains code functions to calculate
which days to insert into the MSOutlook database based on the criteria
selected in the Recurrence form. I am looking for examples that
illustrate these exact functions that calculate these dates. NB:I am
not looking for the intrinsic date functions that you find as part of
any programing language (ie: Date() or DateDiff() etc). I need the the
examples in VBA or VB.

Many thanks

---

Request for Question Clarification by hammer-ga on 07 Apr 2003 06:37 PDT

If you want the "exact" functions used by any particular version of
Outlook, you access them from VB by using Outlook automation, which
requires the user to have Outlook on the system. Would a library of VB
recurrence functions that do the same operations as Outlook suffice?
If so, what version of VB do you need?

- Hammer

---

Clarification of Question by datasys-ga on 07 Apr 2003 11:16 PDT

Hi Hammer,

VBA functions would be preferable, if possible?? Being OK with VBA I
suggested VB as an alternative that I could study/take apart/re-build
in MSAccess. If VBA is not available then a VB Library would be great.
I have no idea which would be more suitable as I don't have or use VB.
However, I may be able to find someone who does and have them
'converted' and re-built maybe. I'll leave it at your discretion

Thank you

Warren

I'm not finding a complete library of recurrence functions. To be
honest, most of these functions invlove a fairly simple call to Date
Serial, et al. In VBA, one builds these functions using DateAdd(),
DateSerial(), DatePart(), etc. There are good examples of doing this
at the MVPS Access FAQ.

MVPS Access FAQ Links:
Various Date manipulation functions
http://www.mvps.org/access/datetime/date0007.htm

Return a date in the future from a given date
http://www.mvps.org/access/datetime/date0003.htm

Doing WorkDay Math in VBA
http://www.mvps.org/access/datetime/date0012.htm

Using these tools, you can build all of the recurrence functions and
then some yourself with little trouble. Perhaps someone else will find
where someone has packaged it up in an Access module.

- Hammer