Search results

Yes, that is the download/install I attempted. The MS Store download doesn't work. The other download is for Office 365 I don't want.

When I installed Office 2021 I had option for Outlook to switch to Classic. New and Classic both show in list of apps. Classic is my default mail app. Even if it isn't, Classic should be there for the CDO code to work with. I have read recent discussions that MS no longer includes Classic with...

On the PC I just checked, upgrade wiped away everything, like an original install. This was my first go at upgrade. Still no sign of Bitlocker after restart. The other PC I chose option to not wipe apps or user settings. I will now have to go check out these settings on that one.

No sign of CoPilot on this PC. gpedit.msc errors "can't find". As for all the other Settings, either I don't find or they are Off. Tried the Bitlocker procedure but it does not show in System and Security. Maybe I need to restart computer.

If it doesn't exist in Access, why did my query work?

Arnel, that just aligns Search and active app icons to center or left side of bar, doesn't position the entire bar vertically to left edge of screen. MS eliminated that option. Doc, could you be more specific about the registry edits? You deactivated features? Seems Bitlocker does not apply to...

github page (https://github.com/valinet/ExplorerPatcher/releases) on ExplorerPatcher says "We DO NOT recommend using EP on work machines running Windows 11 version 24H2". Also, says will have to work around virus detection because Microsoft flags it as malware. I'm not disappointed enough to...

Here's what the cartridges look like.

I have old cartridge printers: Brother MFC-J1410W and HP Envy 7645. The Brother cartridges don't appear to have any electronics, just a reservoir as you noted. The HP cartridges have what looks like electronics, maybe why they are so expensive. I am going to try refilling cartridges.

I upgraded 2 HP Pavilion laptops that did not meet "minimum" requirements. As The Doc indicated, requires workaround. Registry hack is one. My effort involved use of a tool called Rufus (https://rufus.ie/en/) which created an install disk of Windows 11 that would go around the restrictions. Both...

Syntax error caused by semi-colon in expression. See post 5.

I expect results will be incorrect because expression is not dependent on any data in the main query. Literal text input of "Morning" should probably be a field. Otherwise, same result returns for every record. I was able to build an expression that did return dynamic result.

I tested that expression structure and it did not error but did not give result I expected. I doubt it will for you even if syntax error is resolved. Remove semi-colon from end of the SQL. (Doc, ANY is seen as a keyword, not a value.) Provide sample data and desired output.

I never heard of it so had to look it up. I tried it and it worked. What happens when you try your expression?

Why save this calculated value to table?

Is the form Header active? If there are no controls in it, don't show it. Also, resize subform containers and page sizes so the tab control can be reduced. Takes trial and error.

Seems Access recognizes hyphen as date part separator when enclosed with # or within string in CDate(). ?#2-2-2025# 2/2/2025 ?CDate("2-2-2025") 2/2/2025 Otherwise, you get subtraction. ?CDate(2-2-2025) 6/14/1894 Allen Browne shows forcing a date to U.S. MM/DD/YYYY arrangement...

Pat, the #'s are included in the strcJetDate constant. See post #2. Tested and works.

strcJetDate is a declared constant, don't enclose in quote marks. You didn't in Immediate Window so don't in your procedure.

Local means variable can be accessed only within the procedure where it is declared. Cdbl() is a function that converts a value to Double data type. Your function won't work. You have made too many bad edits to the code Isaac provided. The first being the function declared name. Then you put...