How to change an Outlook appointment

[greaseman]

I know how to create an appointment in Outlook from a form in MS Access with VBA code. My question is: Suppose the date and time in my Access table and form are changed..... how would I go about changing the date and time of the appointment in Outlook, using VBA?

Would I have to somehow delete the original date and time of the appointment, and then save the new date and time of the appointment?

If anyone has a little piece of code or pseudocode, or just some good ole advice, I'd be very appreciative.

Thanks in advance!

 

[KeithG]

Just change the Start and End property with VBA for the appointment.

 

[greaseman]

KeithG,

Thanks for your reply, however I'm not sure what you're telling me. In my code:

Dim outobj As Outlook.Application
Dim outappt As Outlook.AppointmentItem
Set outobj = CreateObject("outlook.application")
Set outappt = outobj.CreateItem(olAppointmentItem)
With outappt

.Start = Me![Customer Review Date] & " " & Time()
.Duration = 120
.Subject = Me![Start this task]
.Save
End With
Set outobj = Nothing

I don't have an .End parameter. Is what you're trying to tell me is that if I only change the Starts and Ends of my appointment, it will get changed automatically in Outlook?

Thanks again for replying!

 

[greaseman]

Hello???? Anybody there ????

 

[greaseman]

Oh, well.....

I figured how to do what I wanted to do in the first place: Code I wrote will delete the appointment if it exists, and re-add the appointment for a different date.

Took a little longer digging for the info myself, but at least it's done.

 

[CharlesWhiteman]

Hello Greaseman, I too have written some code to add an appointment to outlook but really not sure how to delete it. Can you give me a clue in terms of the code you used for deleting the appointment please?

 

[webmeister]

Hi, Charles,

I searched my opld files to try and find that code, but, that was quite a while ago! Looks like I have since removed the code or removed the program.

Wish I could help you out, but am not able to. Try searching for erasing / changing outlook appointment entries or things like that.

In the meantime, I'll keep searching my archived stuff and will re-post if I find it.

 

[CharlesWhiteman]

Many thanks for the reply. i will research as recommended but thanks for taking the trouble to reply.