Search results

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

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?

You're absolutely correct.

Thanks everyone for your help!

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

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

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

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

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

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

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!

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.

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

Correct - I want them enabled.

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

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

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

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.

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

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