Search results

  1. J

    Unable to create .accde

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

    Unable to create .accde

    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...
  3. J

    Cannot create .accde in 64-bit

    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...
  4. J

    Cannot create .accde in 64-bit

    Wanted to add that the .accdb appears to run ok
  5. J

    Cannot create .accde in 64-bit

    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
  6. J

    Interface between Access 365 with Calendar in 365 Business

    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
  7. J

    Interface between Access 365 with Calendar in 365 Business

    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...
  8. J

    Interface between Access 365 with Calendar in 365 Business

    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...
  9. J

    Interface between Access 365 with Calendar in 365 Business

    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...
  10. J

    Interface between Access 365 with Calendar in 365 Business

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

    Interface between Access 365 with Calendar in 365 Business

    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 :)
  12. J

    Interface between Access 365 with Calendar in 365 Business

    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...
  13. J

    Interface between Access 365 with Calendar in 365 Business

    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...
  14. J

    Interface between Access 365 with Calendar in 365 Business

    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.
  15. J

    Interface between Access 365 with Calendar in 365 Business

    Or more specifically a specific Calendar Folder
  16. J

    Interface between Access 365 with Calendar in 365 Business

    Many thanks for your very useful post. The output is as follows: user1@kosmosbusiness.onmicrosoft.com Outlook JohnPapaioannou@kosmosbusiness.onmicrosoft.com The question remains as to how to write to a specific folder (Outlook), basically update a specific Calendar.
  17. J

    Interface between Access 365 with Calendar in 365 Business

    I set the default Outlook to the one beginning with "User1...", by going to File --> Account Settings. When I now transfer the appointment info from the Access db to Outlook, all updates take place in the Outlook starting with "User1..." So if we can find a way to set the default Outlook, we...
  18. J

    Interface between Access 365 with Calendar in 365 Business

    I added a third Outlook (second Exchange Outlook), as indicated below: When I transfer the appointment info from the Access db to Outlook, all updates take place in the Outlook starting with "John.."
  19. J

    Interface between Access 365 with Calendar in 365 Business

    Maybe the following picture clarifies the situation "Outlook" is my original PST Outlook. "johnpapaioannou@kosmosbusiness.onmicrosoft.com" is my trial Exchange based Outlook. Today I will add another Exchange Outlook.
  20. J

    Interface between Access 365 with Calendar in 365 Business

    The situation is as follows: On my local Outlook I have a pst-based Outlook and another Outlook which syncs with Exchange. When I use the following code from withing Access 365 the Ace DB appointments get copied to the Exchange based Outlook. Any ideas on how to identify all Outlooks and update...
Back
Top Bottom