From Access: Find an Outlook Task & Delete It

[trevorwilliams2]

Scenario:
I have created a VBA utility that posts, from Access, Outlook calendar & task items items to public Exchange folders.

I have created a routine, using an Exchange table link to the Public Calendar that checks to see if that particular calendar item has already been posted from my Access DB.
This prevents duplicates and allows the user to overwrite the Calendar Appt. if it needs to be updated. It does this by comparing a database record and the Title of the Appt. in Outlook.

My Problem:
The linked table & data available from Exchange for Tasks is limited and I have now way of comparing my database Task item against an existing Outlook Task item.

Question:
I need a way to compare a database task item against an existing Outlook Task item to see if it exists, and if it does, update or delete it.

Any ideas?

 

[kjv1611]

This might be worth looking at:

http://www.dicks-clicks.com/excel/olTask.htm

And this seems at least a little related:

http://www.xtremevbtalk.com/archive/index.php/t-185614.html

--

"If to err is human, then I must be some kind of human!" -Me

 

[trevorwilliams2]

The first link did the trick! Many thanks kjv1611!