Search results

  1. 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...
  2. I

    VBA API call standards

    Good to know it's possible and you have implimented it successfully theDBguy.
  3. I

    VBA API call standards

    Thank you for providing these links. I will review the code.
  4. 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...
  5. I

    Updated Access and now my Environment is slightly corrupted.

    I was able to resolve item 1) Now when I reboot my machine 2 Instances of MS Access load on Startup. I turned off the Sign-in Option which resolved the issue. (See attachment) 2) When I close an MS Access file and then open another MS Access file immediately, it takes several seconds to open...
  6. I

    Updated Access and now my Environment is slightly corrupted.

    Speaking of Restore Points why is it Disabled by Default in Windows 10? Could of been Handy Right now.
  7. I

    Updated Access and now my Environment is slightly corrupted.

    isladogs is it safe to Unistall Office 64 Bit and Re-install Office 32 Bit without rebuilding the machine? Thanks
  8. I

    Updated Access and now my Environment is slightly corrupted.

    isladogs is correct. The Default Office Install is now 64 Bit. (See Screenshot) My new Dell Machine came shipped with Office 64 Bit installed and so will all future machines. My experience with 64 Bit MS Access has not been a pleasant experience. The Compact and Repair Bug completely breaks...
  9. 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...
  10. I

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

    Microsoft now installs Office 2019 in 64 Bit by Default. My new machine from Dell came installed with Office 64 Bit and this will be the trend going forward. I personally don't need any of the 64 Bit features.
  11. I

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

    I've been doing more research on making VBA 64 Bit compliant. I downloaded the Win32API_PtrSafe text file from: https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bit-support Below is one Declaration I'm using in my code. The above document...
  12. 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...
  13. I

    Rick Fisher's Find and Replace in Access 2019

    Hi isladogs, Yes I have had the license for a while. Good to know there are some alternatives if I encounter any issues. Thank you.
  14. I

    Rick Fisher's Find and Replace in Access 2019

    I installed it on my machine. It appears to work well with my initial testing. Fingers Crossed. I installed the 64 Bit version as I am using the 64-Bit version of MS Access 2019.
  15. 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.
  16. I

    Optimization Algorithm

    Thanks for everyone's responses. I was able to solve the problem with Excel's Solver Add-in and using Automation in MS Access. Excel's Solver is extremely powerful. Excel's solver can solve the optimization with 10 buckets and 7 constraints extremely fast and efficiently.
  17. I

    Optimization Algorithm

    Hi Gizmo, Thanks for your response. You are correct the problem outlined is the base case. The actual problem involves 5-8 buckets, and additional restrictions on the final blend such as > Y %, < Z %, on top of the 100 L volume and <= 25 % water restrictions. Also please note that Dollar...
  18. 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...
  19. I

    execScript (JavaScript) throws Access Denied Error in VBA

    vbaInet, Adding <!-- saved from url=(0014)about:internet --> "Mark of the Web" to the top of the HTML file resolved the issue on another user's machine in a completely different organization as well. I confirmed this user had Access 2010 installed on their machine. It appears the cause and...
  20. I

    execScript (JavaScript) throws Access Denied Error in VBA

    vbaInet, Adding <!-- saved from url=(0014)about:internet --> resolved the issue on one problematic machine according to the IT Department and based on their detailed response I am fairly confident it will work on the rest. If not, I will follow up here again. Thank you again.
Back
Top Bottom