Deleting an Outlook Appointment from Access VBA
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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)
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
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
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
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?
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
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.