Recent content by JohnPapa

Tested it again this morning. I tried it with Bitdefender on. It gave the problem. I disabled Bitdefender for 5 minutes and I was able to create the .accde immediately.

I mentioned it immediately after I found out. I found out though another ticket which I opened yesterday.

I found out today the reason of the problem regarding the inability to create a .accde file in A2013. This thread has 50 entries and surely a source of great information and once again I thank everyone for their contribution. The problem was caused by my antivirus, BitDefender. Once I disabled...

Fixed. I was able to create the 64-bit .accde when I disabled the antivirus software, in this case BitDefender. With the antivirus on on different pcs, the 32-bit .accde is created , while the 64-bit is not. So if you are having problem with creating .accde, you may look at any antivirus...

Wanted to add that the .accdb appears to run ok

I get, "Could not use <Specific filename.accdb>. File already in use." when I try to create the .accde using 64-bit A365. The .accde is created ok when I use the 32-bit A365. Both the 32-bit and the 64-bit use the following Version and Build

The following works fine and deletes ALL the filtered appointments. Many thanks. I will post both the Delete and Export Code again. Dim i As Integer For i = olFilterAppointments.Count To 1 Step -1 olFilterAppointments(i).Delete Next

The number of filtered (to be deleted) appointments is olFilterAppointments.Count When you say Loop do you mean using For Each ...Next. I will remind that we are talking about a Collection with no apparent unique ID and the current Delete loop is For Each olAppointmentItem In...

I have modified the code a bit, and the Collection is now only the appointments that need to be deleted (not all the appointments). When I call the Delete sub, all appointments are deleted except the last one, which is deleted if I call the Delete sub again. As it has been suggested by Gasman...

This is the code for deleting all appointments that have Location = 123 There is one problem. The following excerpt does not delete the last appointment. If there are 3 appointments it will delete 2 of the 3. For Each olAppointmentItem In olFilterAppointments Debug.Print...

You are right. I guessed it prior to looking. Thanks anyway. Will post all the code for posterity.

I can loop through each appointment. I will post the code. I have not figured out how to delete an appointment. One thing at a time :)

Your concern is valid and raises a question. If the Exchange Outlook for each dentist will be used to display the dentist's appointments as a read only feature then it is OK. If the user enters additional personal data, then there is a need to be able to delete all appointments that we copy...

There is no problem updating any Outlook and this works very well, especially with your help. The challenge I am facing now is prior to the update, to be able to delete ALL entries of a specific day of a specific Outlook, so that when I do the update the Outlook would hold the latest data. I...

Works like a charm. Can't thank you enough. I was just reading about the Outlook model and was getting to the solution. The documentation is very verbose.