Search results

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

The function requires input for 4 arguments. You provide only 2 then you throw in AND ... . This makes no sense. Look at Isaac's example again.

VBA code goes in a VBA module, not in a query. Do you know how to open the VBA editor? VBA code can be behind forms and reports or in independent modules. I expect the code you reference needs to be in an independent module. An expression in query can call a VBA Function procedure (not a VBA...

Some Options: 1) pass calling form name to frmArticoliCerca with OpenArgs 2) pass other info to frmArticoliCerca with OpenArgs 3) calling forms set global variables or TempVars that are available anywhere

Hard to say. What do you already know about programming? Ever programmed in any language? The basic concepts are transferrable. Start with review of https://support.microsoft.com/en-us/office/introduction-to-access-programming-92eb616b-3204-4121-9277-70649e33be4f It's considered good etiquette...

Rearranging data from horizontal to vertical is a red flag that data is not normalized. But as long as you have it handled and solution works, call it done.

If you want to get this resolved, really need to provide file - follow instructions at bottom of my post. That way we can design and test with your schema.

I did suggest saving the discount % was an option. Would be interesting to know how retail store programs document discounts: member and sale discounts on specific products, mfr coupon, then maybe a discount off the entire purchase. I expect a record for each.

I don't see need to save SellingPrice to Products table. It can be calculated when needed. Only reason to save in OrderDetails is if the percentage can vary over time. In which case, maybe the percentage should be saved, not the calculated result. This is the same justification for saving...