Search results

Hi The Doc Man, Difference in file name is because we have hundreds of XLSM files where we are reading tags and other properties on daily basis. All of my XLSM files have the same attributes as it were before. I am afraid if recent Windows10 update has caused this issue on computers? Here is...

As I said this has stopped working recently and I will appreciate if there will be any directions to troubleshoot/fix this?

Hello, Thanks for providing example code. I am using Colin @ridders code provided in post # 5 and tested on 02 different computers running Windows 10 and Office2016. All I need is to get Comments/Title/Tags property for any XLSM file. I have noticed that GetDetailsOf method stopped getting...

Hi, I have used GetDetailsOf method to retrieve extended file properties to read Comments (objFolder.GetDetailsOf(strFileName, 24), Title (objFolder.GetDetailsOf(strFileName, 10) and Category objFolder.GetDetailsOf(strFileName, 12). This was working before and I have noticed that it is not...

Hello, I have recently started doing Access desktop as front-end and split backend to SharePoint Online and it is working great when it comes to allow multiple users to work on the database at the same time from different locations. It was also working great if any of the user is working...

Sure, thanks

Did you mean that desktop access apps connected with SharePoint online/Office365 will not be affected in any way? I am hoping that access desktop users will still have the following 03 options with SharePoint connected backend (https://goo.gl/uFmz3A)?

Hi Colin, thanks for suggestion and sharing link. Does that mean Access Desktop (ACCDB) will no longer work with SharePoint? My only need is to have a centralized backend where multi-users can work on the database from different location?

Thanks Colin, I am still struggling and Is there a way if we can setup local table within Access or is it simply not possible?

Sorry how to use local temp tables? I could not find an option to create local temp tables? Any table created sync automatically on SharePoint? Also check table options/icon in screenshot https://goo.gl/Cvpo6r

Hi, I am working on Access project where Access tables are published to SharePoint. There are some client forms that requires to Make/Drop some temp tables for calculation and I donot want them to Sync to SharePoint. I can see that temporary tables took some time to create as it Sync/publish...

Thanks CJ, it worked

Hi, I am getting data type mismatch on AddressOf operator. Is there any alternative available that I can use instead of AddressOf that is compatible with 64bit Office? Thank you Mohsin

I am working on excel file that enabled VBA Object Model Through SendKeys for all English language users, SendKeys are not working for Users with Office Spanish version. I am hoping if anyone help in translating SendKeys to spanish version? I have placed my code snippets below. Public Sub...

I have an array that returns number of sites with [Zip code]. I want to parse [Zip code] and want the array to sorted with Exact Match or Closest Match? How this can be done? Thank you

Hi Arnelgp, Thanks for your help, what I would further do is bulk editing in Microsoft Outlook linked contacts. Instead of importing contacts in Access, Is there a way if we programatically create/refresh a link table in Access? Dim strOutlookPath As String strOutlookPath= "Outlook...

Hello, I want to programatically link to Microsoft Outlook Contacts in Microsoft Access? How can I do this with VBA? Basically I want the first option is to allow the user to select Outlook Account >> Contacts folder (Please note that there are several Outlook folders exist). Once the User...

Thanks CJ for your help, Yes to automatically find an outlook file and refresh the link. I am able to get that working properly.

Hi CJ, Thanks for the prompt response, Is this still work if I use this copy of database on a different machine (as the outlook folder location/machine name) on the other machine changed and inbox folder link broken. I am getting the following error 'Mapi Folder or Address Book not found' and I...

Thanks CJ for the idea, can you please share some lines of code or any helpful link that will only to refresh one refresh link 'Inbox' table to 'Outlook' default folder? Or is there anyway to automatically drop/relink the Outlook 'Inbox' folder by DoCmd.TransferDatabase acLink outlook folder?