Search results

  1. I

    Solved CDO Email: 530 Authentication Required

    Hello MS Access Expert, I am receiving the below 530 Authentication Required error despite having Authentication turned on in my VBA code (See below). The email provider I am using is 1and1 with the below posted settings. When I turn on .Item(sch & "sendtls") = True I still receive the same...
  2. I

    MS Access slow when two identical Queries are opened simultaneously

    Hello MS Access Expert, Suppose I have a table Y with 30K records and I have two queries in MS Access which are identical (SQL = Select x from Y where x = "a"). When I open the first query the results appear instantly. While keeping the first query open, I subsequently open a second identical...
  3. I

    Shift Mode does not Maximize MS Access

    Hello MS Access Expert, When I open an .accdb file using shift mode it does not Maximize on my screen. It merely appears in my Taskbar and then I have to click it to maximize it on my screen. The peculiar aspect is that if the file is Not in a folder but rather on my desktop it always...
  4. I

    Do most MS Access developers use DRIVER={SQL Server} in the ODBC Connection string?

    Hello MS Access Expert, If I have ODBC Driver 17 for SQL Server in the ODBC connection string I presume that would require me to install this driver on the client's machine? However, suppose the client gets a new computer later on and it has ODBC Driver 18 installed. Will that break my ODBC...
  5. I

    ODBC Connection Fails when I remove a Field from SQL Server Table

    Hello MS Access Expert, I noticed that when I delete a field from the SQL Server table the ODBC connection subsequently breaks. Additionally, if I add fields to the SQL Server Table the ODBC connection does not break but the newly added fields do not show up. The only solution that I have...
  6. I

    Inconsistent SQL Server Query Behavior (Form Reference Criteria vs Hard Coded Date)

    Hello MS Access Expert, I am experiencing different query results when linked to SQL Server Tables, specifically, when I hard code criteria vs. a Form Reference. Note I don't experience this discrepancy when using Local MS Access Tables. I have attached the example database as a Zip. I have...
  7. I

    FMS Visual Code Tools replacement

    Hello MS Access Expert, Unfortunately, it appears the latest FMS release does not support a 64 Bit environment. I recall there was a free Tool that offered very similar features to FMS Visual Code Tools but I cannot recall the exact name. Can you provide the name and link for this free VBA...
  8. I

    SSMA Query migration

    Hello MS Access Expert, I am learning how to migrate MS Access objects using SSMA into SQL Server 2019. I was not able to Migrate the following query using the SSMA wizard and I am curious why. SELECT Invoice.InvoiceNo, [Quantity]*[UP] AS Total, Month([Invoice].Date) AS [Month], Invoice.Date...
  9. I

    VBA API call standards

    Hello MS Access Expert, I would like to know if it is possible to make API calls via VBA that meet the below standards: Ability to adhere to TLS 1.2 encryption for HTTPS connection Ability to support OAuth 2.0 JSON Web Token (JWT) Bearer Flow I have a MS Access system that has been in...
  10. I

    Updated Access and now my Environment is slightly corrupted.

    Hi Access Expert, I updated my MS Access 64 Bit via the Office Update Method (See attached Screenshot) and now my environment is slightly corrupted. 1) Now when I reboot my machine 2 Instances of MS Access load on Startup. 2) When I close an MS Access file and then open another MS Access file...
  11. I

    Access WinZip Code for 64 Bit - Written / Revised by Albert D. Kallal.

    Hello MS Access Expert, My new machine came with Office 2019 64 Bit, hence, I have MS Access 2019 64 Bit installed. My application no longer compiles due to the Declare statements. I have been reading how to make the VBA 64 Bit compliant and it seems to be pretty straight forward if there...
  12. I

    Rick Fisher's Find and Replace in Access 2019

    Hello MS Access Expert, I have been using Rick's tool in prior versions. Does it still work effectively with Access 2019? I wanted to get the communities feedback prior to installing it. Thank you.
  13. I

    Optimization Algorithm

    Hello Access Expert. I would like to know if the below is possible in Access / VBA and if so can I leverage something on the internet to get me started? Thank you, Suppose you have three buckets A, B, C Bucket Capacity % Water $ A 70L 10% $1 B 80L 30% $2 C...
  14. I

    Installing Office 2007 after 2013

    Hello, I purchased a new machine. I didn't realize Office 2013 trial was installed as there was no indication that it was in <All Programs> etc... I installed Office 2007 and spent many hours setting up my new development environment only to realize an Office 2013 trial was installed when I...
  15. I

    How do you handle DPI Scaling other than 100%?

    As more and more laptops and monitors come with higher resolution screens DPI scaling other than 100% is becoming more popular. At 125% DPI Scaling some field captions in my software built for 100% get cut off or are misaligned. Also the DPI scaling can theoretically be anything as it can be...
  16. I

    execScript (JavaScript) throws Access Denied Error in VBA

    On some machines I receive the Error: "Access is Denied" Error #: -2147024891 when initiating JavaScript from within VBA. Call Forms("frmMap").WebBrowser.Document.parentWindow.execScript("initialize()", "", "JavaScript") Is this a security setting in Internet Explorer ? I don't have much...
  17. I

    Place Image File into the ClipBoard

    Hello Access Expert, I would like to place an image file located at e.g. "C:\MyImages\image.png" into the clipboard. I have not been able to figure out how to do this. I have been able to place Text into the Clipboard using the DataObject late binding sub below. Thank you Public Sub...
  18. I

    Save Form / WebBrowser Control Contents to an Image

    Hello Access Expert. I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map. I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do...
  19. I

    Set Focus Back To Access Application

    Hello, In my VBA I open the default browser using the following code. Application.FollowHyperlink "http://www.google.com", , False Right after opening the browser I would like Focus to go back to Access. How can I do this? Thank you
  20. I

    Programming PivotChart Form

    Hello Access Expert, I have created a PivotChart Form. In the Open Event of the form I would like to Select specific categories determined at runtime for each of the Drop Zones / Filter Combo Boxes. So for example if one of the Filter Combo Boxes has a list of Provinces I want to be able to...
Top Bottom