Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.
Notifications
Clear all
Nov 24, 2024 11:13 pm
What am I doing wrong here.....I remember something about using single-quotes instead of double-quotes on statement inside the whole statement double-quotes with MS Access 365. Seer attached image to see where the error is pointing to as the problem. I have triple and quadruple checked against your code on YT.
docmd.RunSQL " UPDATE tbl_Order_Items " _ " SET tbl_Order_Items.ItmQtyInvoiced = " & inv_ord_q & ", " & _ " tbl_Order_Items.itmQtyInvoiced = " " " & inv_ord_q & _ " " " WHERE tbl_Order_Items.OrderItemsID = " & me.OrderItemsID & ""
2 Replies
Nov 24, 2024 11:24 pm
Well, it happens every time, I get frustrated and reach out for help and then a flash happens, and I see the problem. in this case I was missing an ampersand sign after the Update line. Corrected the code and it now my where statement is off somehow.....
DoCmd.RunSQL " UPDATE tbl_Order_Items " & _ " SET tbl_Order_Items.ItmQtyInvoiced = " & inv_ord_q & ", " & _ " tbl_Order_Items.itmQtyInvoiced = """ & inv_ord_q & _ """ WHERE tbl_Order_Items.OrderItemsID = " & Me.OrderItemsID & ""
Nov 26, 2024 2:59 am
Received the source files this morning and spent a few hours cleaning up the mess I created in my version of the project. Thank you Ursh, you saved me again. All my SQL statements were trash as well as I misnamed the two critical sub forms using sfrm_ instead of tbl_. Speaking of which, why did you do that? Typically, I look at coding to direct me to the object I need to focus on. If there is a reason for later needed in the project, please advise.
