Topics Search

Deleting an Outlook Appointment from Access VBA

Deleting an Outlook Appointment from Access VBA
Views: 39
Trying to figure out the object variables required to find and delete an Outlook appointment from Access. I understand the principles but cannot get anything to compile. Is there a simple set of generic object varialble that will open up my outlook calendar on my laptop and delete an appointment based upon Subject, Start & location
Sponsored Links:

More topics

 

Create Outlook Appointment from Access

Preview
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
 

Open Outlook Appointment form and populate some fields for validation

Preview
I have been tasked with making an addition to my Access 2007 database, we want to create a button on a screen that will open up the Appointment screen from Outlook (not directly create the appointment), and populate the Subject line and invited attendees from fields within Access (user will need to check the schedule for the time to schedule the appointment and add additional data). Once the appointment has been saved, we would like Access to update a checkbox to show the appointment has been scheduled. Since I am pretty green with VB and Access
 

Code to open a new appointment

Preview
I have seen various threads about setting an outlook reminder based on an appt table and then a form. All I want to do is have a command button which opens outlook and opens a new appointment in the calendar for the user to enter the reminder information themselves.

I have the code below to open outlook but it opens a new copy of outlook (even if outlook is already open) and I dont know how to open the calendar or new appointment.

Private Sub Command69_Click() On Error GoTo Err_Command69_Click
Dim stAppName As String
stAppName = "C:\Program Files\Microsoft Office\OFFICE11\OUTLOOK.EXE"
Call Shell(stAppName, 1)
Exit_Command69_Click:
Exit Sub
Err_Command69_Click:
MsgBox Err.Description
Resume Exit_Command69_Click
End Sub

So to summarise, I do not want to automate an appointment with another form, just open the window for the user to enter it directly to outlo
 

Delete Outlook Appointment

Preview
I have searched but can't find code to delete an appointment item from local Outlook installation. I'm trying to start here to test the code, then move on to a shared Outlook folder when all is worked out.
 

Outlook calendars

Preview
fellow AWFers

I have some VBA code that enables me to enter appointment data in Access and this creates appointments in the default Outlook calendar.

I would like to be able to write data to different calendars so I can have one to handle the scheduling of jobs and say another to show engineer's holidays etc.

Does anyone have experience of writing data to outlook and how I can programmatically create or access calendars other than the default one
 

Repeat Element Of Code Based upon Subform

Preview
I am using some code from Accesstips to create an appointment in Outlook, using information from my form JobNumber.
Now I have been asked to allocate employees to jobs and also create the same appointment in outlook for each employee allocated to job as a seperate appointment.
I have created a subform which allows each employee to be allocated to the job.
What I am looking for is to repeat the appointment creation code for each employeeid on the subform
 

Exchange calendar appointments

Preview
So I'm aware that there is standard vba programming that can add an appointment to the default outlook calendar, but for my work I would like to be able to add an appointment to a shared Exchange calendar stored on a network server. It also has custom forms on separate tabs that I would love to be able to add information from the applicable record to. Is there a way to reference the exchange calendar and the specific tabs in the appointment
 

Exchange calendar appointments

Preview
So I'm aware that there is standard vba programming that can add an appointment to the default outlook calendar, but for my work I would like to be able to add an appointment to a shared Exchange calendar stored on a network server.

It also has custom forms on separate tabs that I would love to be able to add information from the applicable record to. Is there a way toreference the exchange calendar and the specific tabs in the appointment?
 

Outlook.SecurityManager

Preview
So far this site has not let me down.

I am attempting to disable MS Outlook security messages temporarily via Access VBA while sending a message. Should I use Outlook.SecurityManager and if so where would I find the vba reference as it is not currently recognizing it. I have the Outlook 12.0 Object Library enabled. If not, any other ideas
 

Update/Delete Outlook appointments from Access

Preview
I've recently created an access dbase that manages customer records and appointments; publishes the access appointment into outlook using a modified code from this site: [LINK]

Now the problem that I am facing is that I am whilst I am able to update/delete the records in access the actions do not carry over to Outlook.