Search results

  1. K

    Resize Form to Original Size

    Thanks everyone for your help. My app can sometimes require a user to deal with multiple forms at the same time (this is especially true during lunch time where there may be only one user in the office.) Unfortunately, his/her task bar ends up looking like the attached screenshot. Since...
  2. K

    Resize Form to Original Size

    I have an Access form which is 8" wide and 6" tall. I minimize it. So far, so good. Unfortunately, when I later maximize it, the form fills the entire screen (which I don't want.) How can I get it to resize to its original 8" x 6" size?
  3. K

    MaxDate and Group

    You're absolutely correct.
  4. K

    MaxDate and Group

    Thanks everyone for your help!
  5. K

    MaxDate and Group

    Bob, Thanks for your help. Your solution works perfectly based on my previous data. Unfortunately, I forgot to mention that not all customers will have the same order dates. My bad. As such, the following set of records: only returns the following: Again, my mistake. What I really...
  6. K

    MaxDate and Group

    I have the following table (attached): I'd like to create a query that displays the Max(OrderDate) details by Customer: OrderDate Customer ItemNum SerialNum 10/3/2022 Andy 300 323456780 10/3/2022 Betty 900 923456789 I've read a few...
  7. K

    Solved Make button specific backcolor

    Perfect! Thanks! Which Hex to RGB converter did you use?
  8. K

    Solved Make button specific backcolor

    Yes, I should have provided more info. I'm using the latest subscription version of Microsoft 365. After the click, my vba code checks a couple of things in my connected SQL database. If all good, I'd like the backcolor to change to that specific shade of green. If not, the backcolor...
  9. K

    Solved Make button specific backcolor

    Actually, no (although I'm sure your solution would work.) In my scenario, when the button is clicked, I need to first check a couple of things in my SQL database before giving it the OK to change color. (I should have mentioned this in my question.) I appreciate your help! kenrav
  10. K

    Solved Make button specific backcolor

    I need to change the default backcolor of a button to #22B14C when clicked. How can I do this? Thanks! kenrav
  11. K

    VBA Issues in Windows 11

    Yep! "Action queries" was disabled. Enabled it and all works fine. Since I know I didn't disable it, I wonder if installing MS 365 on my new laptop (or perhaps a recent update) disabled it? Regardless, thanks for your help!
  12. K

    VBA Issues in Windows 11

    You are correct. I just ran this 2-line script: strSQL = "Update tblTest Set Field2 = #" & Now & "#" DoCmd.RunSQL strSQL Message displayed under Windows 10 and Server 2019, but not Windows 11.
  13. K

    VBA Issues in Windows 11

    All, Keep in mind that this isn't a coding issue. Many of my apps have been around for years. The issue is that these apps display the desired warnings on previous versions of Windows but not on Windows 11. I'm just curious whether anyone has seen anything unusual in Windows 11 with regard...
  14. K

    VBA Issues in Windows 11

    Correct - I want them enabled.
  15. K

    VBA Issues in Windows 11

    I don't typically use macros. Fails under VBA.
  16. K

    VBA Issues in Windows 11

    I wrote a small app for testing: strSQL = "Update tblTest Set Field2 = #" & Now & "#" DoCmd.SetWarnings True DoCmd.RunSQL strSQL On my Windows 10 and Server 2019 devices, Windows displays a warning message (after line 3) that 1 record is being updated (see attached screen shot) which is what I...
  17. K

    VBA Issues in Windows 11

    I recently upgraded to Windows 11. I'm fully updated and have the latest Office 365 updates as well. Unfortunately, I'm finding that my "DoCmd.SetWarnings True" VBA actions no longer work in all my legacy Access apps. The action still works fine on my Windows 10 and Server 2019 devices. Anyone...
  18. K

    Adobe Integration Issue

    After first telling me I needed to upgrade to an Enterprise License (wrong) followed by "it's impossible to roll-back to my previous version" (wrong), I received an email today from Adobe with excellent instructions on rolling-back to my previous version. As expected, all good now.
  19. K

    Adobe Integration Issue

    It appears I may have sorted this out. As you may recall, my VBA "Save" command stopped saving newly-edited pdf files sometime recently. Using two PCs, I tested several configurations and this is what I found: Fully-updated (Microsoft) + Adobe Acrobat DC (installed 1/12/22): Doesn't work...
  20. K

    Adobe Integration Issue

    From within my Access app, I've been able to open, edit, save and close a pdf file using the Adobe Acrobat reference. The app had been running great for several months. Recently, the VBA "Save" command no longer saves the pdf. I have verified this issue on multiple devices and similar Access...
Back
Top Bottom