Automate export of Appointment Insert/Update/Delete infomation to the database

C

cookiesncreamychoc

Hi All,

I'm a newbie and have managed to create an add-in (VB 2005) that stores
all the appointment times against the contacts entered in the contacts
field of the appointment form (Outlook 2003) in a SQL 2000 database.

Is there a way to automate the updating of database on clicking the
save button for an appointment in the appointment form or moving the
appointment in the calendar?
I have found some (barely enuf) info about the AppointmentItem.Write
and MAPIFolder.Items.ItemAdd events but I'm not sure abt how to use
them.

Any help wud n appreciated.

Thanx
 
C

cookiesncreamychoc

I managed to fix this ...thanx anywayz guys...

But i just have another question with the ItemRemove event of the
calendar folder as the item is not passed as a parameter (unlike
ItemAdd and ItemChange events) I need to update a column in the
database. How do I retrieve the AppointmentItem in this instance??

Thanx
 
C

cookiesncreamychoc

I manged to get that one sorted too....
thanx ppl.... i must have Sue Mosher's thinking hat on ;) !!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieve Name from the Contacts in the Appointment form 1
automate access2000 form; patient name,date,time of appointment 1
Automate database to link to outlook calendar, e-mail 1
output patient name,date and time of appointment to outlook calendar 1
When working with an appointment form, does the SEND UPDATE button really performing the DELETE and 1
Automate Export to Excel upon Close of Database? 1
The creator of our database left years ago, and we want to update it! 5
When to update the database when moving through a series of forms 3

Top