Create Outlook Appointment from Access

[music_al]

I have 3 related tables...

tbl_Customer
tbl_Customer_Treatments
tbl_Appointments

It might be obvious, but a customer can purchase many treatments and each treatment can occur over many appointments.

In the appointments table I am capturing the Date, Start Time and End Time of the appointment.

As a separate process, the users of the database also have to enter the appointment in Outlook, but I would ideally like Outlook to have an appointment automatically created. Does anyone know how this can be done or are there any Outlook type calendars that I can embed into my database ?

Thanks in advance

Allan

 

[John Big Booty]

Perhaps one of the articles here will give you some pointers

 

[music_al]

Hi John

I found this article

I followed it to the word and it works great. The problem with this is, I view my appointments in Datasheet View and when I view in datasheet, the button disappears.

If you or anyone else has any ideas of how I can make this work in Datasheet view, I would be most grateful.

Many thanks

Al

 

[John Big Booty]

You could make you data sheet form a sub form and have the button on the main form. You will probably have to check the correct syntax for referencing your sub form