Is there a way to use the Outlook Calendar in Access?

[Clay]

Hello everyone,

I am in the process of building a database in Access 2000
which I plan to use to store info about our client's and
their sites. I also want to use this database to schedule
onetime and recurring maintenance activities for each
client or site and have a history of these activities
stored within the DB. Is there a way to use a calendar
like the one in Outlook to select recurring or onetime
activities based on the day, month, etc for each site? If
so, what is the best way to accomplished this?

Any help or suggestions that you might have would be
greatly appreciated.

Thanks,
Clay

 

[Sean]

I thought I saw some examples of this being done on the net when I was
looking at some Windows Scripting Host examples or vbscript examples
sorry I can't be a bit more precise, but I reckon you will find what you
need out there.

 

[Bruce M. Thompson]

I am in the process of building a database in Access 2000

which I plan to use to store info about our client's and
their sites. I also want to use this database to schedule
onetime and recurring maintenance activities for each
client or site and have a history of these activities
stored within the DB. Is there a way to use a calendar
like the one in Outlook to select recurring or onetime
activities based on the day, month, etc for each site? If
so, what is the best way to accomplished this?

Any help or suggestions that you might have would be
greatly appreciated.

You might find the following KB article useful:

ACC2000: How to Use Automation to Add Appointments to Microsoft Outlook
http://support.microsoft.com/?kbid=209963

And for more links to sample code, see:
VB and VBA in Outlook Development
http://www.slipstick.com/dev/vb.htm#samples