Search results

I have managed to have Outlook sync to the cloud, so as you mentioned, the problem is now to be able to update specific folders. The link you sent seems promising. I will review. Thanks.

Hi Colin High marks for effort to CoPilot. Compare to the one I came up with. The first one is CoPilot's Public Declare Function ezGetFileInfo Lib "msaccess.exe" Alias "#56# (FSI As ezGetFileInfo, ByVal fOpen As Integer) As LongPtr Public Declare PtrSafe Function ezGetFileInfo Lib...

Finally, I managed to change everything with no compile errors. Will now do some testing.

EDIT: Found Declare PtrSafe Function GetUserDefaultLCID Lib "kernel 32" Alias GetUserDefaultLCID () as Long

One more Declare Function GetUserDefaultLCID% Lib "kernel 32" ()

The .accdb is 75Mb!

As I mentioned in #9 the original declaration #1 was changed in #4, so the suggestion was not for the correct declaration. I am trying to change a big 32-bit program to 64-bit. I could be wrong, during testing it may work for some data and not work for other.

In addition to Public Declare Function ezGetFileInfo Lib "msaccess.exe" Alias "#56# (FSI As ezGetFileInfo, ByVal fOpen As Integer) As Long I found another one as follows Declare Function apiCopyFile Lib "kernel32" Alias "CopyFileA" _ (ByVal lpExistingFileName As String, _ ByVal lpNewFileName...

If you look at #1 the original question was about Public Declare Function ezGetFileInfo Lib "msaccess.exe" Alias "#56# (FSI As ezGetFileInfo, ByVal fOpen As Integer) As Long It got switched to something else in #4

You say that I cannot directly connect Access to M365, but I can connect Access to local Outlook, which can be synced (automatically) to M365, so the user can view the appointments over the Web? I am not sure about the way the appointments make their way to the cloud.

There is no problem in granting permissions. Do you know the command that I would use to write to specific calendar, instead of the default calendar?

Let's do a restart. The client is using 365 Business where he has access of the calendar on the Cloud. In this 365 Business he has 5 users with their own emails. I can output from my A365 DB to the local calendar, which I am guessing is synced with the Cloud data, BUT I want to be able to write...

Did not. Will look into it. Thanks.

I use something like the following to output to the default calendar Public Function funOutputAppointmentToOutlook(dtmDate As Date, strSubject As String) Dim olApp As Object Dim mNameSpace As Object Const olFolderCalendar = 9 Const olAppointmentItem = 1 On Error Resume Next Set olApp =...

Was wondering whether Access 365 installed on a pc can update the calendar of 365 Business, which apparently is stored on the cloud? If this is possible, then the next requirement would be to update a specific calendar belonging to a specific user.

I am not targeting anything earlier than A2013. So based on the above, is this the correct syntax #If Win64 Then 'Public Declare PtrSafe Function Private Declare PtrSafe Function GetSystemMenu Lib "user32" (ByVal hWnd As LongPtr, ByVal bRevert As Long) As LongPtr #Else Private...

I am having a problem with finding the 64-bit version of the following Declare. I notice that its Lib is "msaccess.exe" Public Declare Function ezGetFileInfo Lib "msaccess.exe" Alias "#56# (FSI As ezGetFileInfo, ByVal fOpen As Integer) As Long The function does not exist in...

Can you control the folder where the Runtime is stored?

Thanks for the info. I believe #13 clears matters. In my case I need to move from A2013 Runtime to the A365 Runtime and being able to install the A365 Runtime without disrupting the existing A2013 setup is very useful. It will only be an interim solution until the migration is complete.

Microsoft can be a bit sneaky... The A2013 Rutime was saved in C:\Program Files (x86)\Microsoft Office\Office15 While the A365 Runtime was saved in C:\Program Files (x86)\Microsoft Office\root\Office16 To confuse everybody there is an "Office16" folder at the same level as folder "root" If...