Search results

Hello everyone, I am facing an issue with the Microsoft Access Edge Browser Control on one of our user's computers, which started occurring yesterday. The user has the same Office365 version Version 2402 (Build 17328.20142) as everyone else, but for some reason, the Edge Browser Control isn't...

Hello, does anyone know how to move the mouse cursor programmatically to the left side of a particular control within a datasheet view of a subform. To clarify I am looking for a way to obtain the x/y coordinates GetCursorPos for the current record's specific control in datasheet.

Does anyone know how to activate annotation settings when navigating to a PDF within the Microsoft Edge web browser control? I have noticed the annotation option while viewing a PDF in the Microsoft Edge browser, but it is not visible when I load the same PDF in the MS Access Edge browser...

Hello everyone, I have a question about the accde version of the database that I distribute to the users, sometimes the application crashes unexpectedly and prompts the user to create a backup of the accde file. This is very annoying and confusing for the users, and I want to fix this behavior...

Hello everyone! I am reposting the question from the thread message link. I am working with the Microsoft Access Edge browser control where I need to share the clipboard inside the new Edge browser control, and I am having some difficulties getting the standard keyboard shortcuts to work...

Hello, Does anyone know how to conceal the scrollbars in continuous subforms within Microsoft Access, particularly when they aren't required? An example would be the grey bars that still show if the subform previously displayed the scrollbars. Does anyone know of a technique or property that...

Hello, With Microsoft's new release of the Edge browser control, which is currently available to Office Insiders and beta subscribers. I see some challenges when it comes to navigating to local html files. Can anyone test and advise if there is a way to navigate to local html file paths (not...

Hello, I am encountering a strange issue with link tables that have insert triggers for some users. Although the triggers do not have an OUTPUT Clause, direct appending to the table is not working properly (screenshot). This problem seems to be occurring for some users, but not for others. Is...

Hello, Hope you all are doing well, I have been using the MailMerge feature to generate dynamic content for the outlook email body and setting the destination to wdSendToEmail. This works really well to send dynamic emails and without any user intervention. My company now wants the capability...

Hi, I am using Mail Merge to generate a contract from Access/VBA. I need to create another version that only contain the acknowledgement/signature pages from the generated document for the client to review and sign. I am deleting the pages for signature version through VBA to keep the one's...

I am working on Microsoft Access project that interacts with outlook to retrieve emails (i-e Outlook MailItems). I got all the required properties from MailItem object. There is one thing that I am looking to do is retrieve Email body in Web browser control on the access form. I am referring to...

Hello, I started getting this type of error in queries. I am using JKP-Ads Pro Treeview controls whose reference is adding in run-time with AutoExec Macro. There are no missing references. Left also works in immediate window, I am not sure but these functions are failing in access queries and...

Hello, I am struggling on formatting text string which is a result of concatenating multiple columns from a table. Here is the scenario I am using Treeview control (MSComctlLib.TreeView) as Treeview does not support multiple columns, I would like to concatenate string and format in a way...

Hello, I am working on something to automate Outlook Rules through Access/Excel VBA, if I am to create Outlook Rule for Single Account it works fine. Is there a way to create Outlook Rule for All Accounts through VBA, I can see this option on Rule Creation Wizard but I am not sure that how can...

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

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

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