Avatar of sharpapproach
sharpapproach
 asked on

Write from Outlook Calendar to Access Database

We have an application that dymaically writes from an Access Database to a Shared Public Exchange Calendar.  When a user changes a date in the Database, it automatically adds, deletes or moves the item on this public calendar.

Now the users want to be able to move one of the items on the OUtlook Calendar and have it change the date in the Access Database.  

How can I do this?  I do have unique data that I link the field with the OUtlook object, so that isn't a problem.  I just don't know in Outlook VBA how to tell it to look at a Calendar entry and when it changes to do something.

Cheers for any guidance!
OutlookMicrosoft AccessProgramming

Avatar of undefined
Last Comment
sharpapproach

8/22/2022 - Mon
Jeffrey Coachman

Have you considered 'Linking' the Outlook data into Access?

Last time I checked, changes worked from both ways...
sharpapproach

ASKER
That feature just creates a linked table.  We have our database that as users add and move things in different tables/fields, etc, then the Calendar updates.  

However, now the users to go the other way.

I have a public calendar called "Study Schedule", and when a user moves an item from one date to another, I have to have it go change some things in access.

I can't figure out how to know in Outlook VBA that a Public Calendar item has been moved/deleted/edited, etc.

If I can figure that out, I should be good to go.
Jeffrey Coachman

Then this seems to be more complex than I had originally thought...

Please wait for other Experts to reply
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
sharpapproach

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Jeffrey Coachman

Great,
Congrats on getting it working, and thanks for sharing the solution with the community.
;-)

Jeff
sharpapproach

ASKER
Figured it out myself and posted code for future users