Access to Outlook Calendar Editing

[xiong]

I am in process of building a small application for track long-term events and deadlines and am researching some possibilites on how best to execute some of my tasks. One of the big problems I am having is the need to create a reminder for an upcoming deadline. Normally this would be a fairly easy task in polling the recordset for certain date ranges and creating pop-ups for pending dates, but in this case the application may not be run for two to three weeks or more at a time, and thus these Access-based reminders would be useless. Another idea is to create a hook to Outlook's Calendar and create an event to handle the reminder function, since I know that Outlook will be open at least daily. So...

When I run the event that will create the record in Outlook, is there a unique ID assigned to that new record that I can capture and record in my recordset. That way I can use that in a routine that will run from Access on all records created by the application and make changes/updates to the reminders that have been set in Outlook?

Example....
InsCo1 has a deadline for application due March 1 next year. The application will run a routine to create an appointment in an Outlook.pst Calendar. This reminder needs to have certain information displayed at the time it shows up such as contact number, case number, etc. In some cases this extra information or even the dates themselves may change. These changes will be made in the application and then updated to the Outlook reminders. Manual intervention by the end-user, as is usually the case, is not recommended.

Does anyone have any ideas on this editing of a known record, or maybe have a better idea?

BTW: Access 2k2, Win 2K


"Only the educated are free.

 

[PHV]

Take a look at the AppointmentItem.EntryID property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244