Recent content by needhelpplz2

Hey, I've filtered a listbox query between two dates selected by a user through an unbound text, however the listbox only changes after you click it. I've requeried it after someone updates the 2 unbound date textboxes, yet it still doesn't work. Help would be greatly appreciated

Hi guys, I've made a report button on my application that is supposed to export results into a pdf file. Here's the weird thing, after it works once if I close it again and try to do the same thing, it gives me a "Run-Time error 3127, The INSERT INTO statement containis the following unknown...

Never mind, fixed it, needed ' quotes around the other one haha... Thanks for all your help

Hello, strSQL = "UPDATE TblInvoice SET IsClosed = -1 " & " WHERE Invc_Number = " & Forms!Main!Invoice!Invc_Number I have tried this too and it still gives me a data type mismatch :banghead:

strSQL = "UPDATE TblInvoice SET IsClosed = '-1' WHERE Invc_Number = '&Forms!Main!InvoiceNumber'" This is much shorter lol XD. I seem to be having trouble with my update queries in general. All fields are valid and the invoicenumber being referenced from main is also being passed properly. For...

Thanks lol that helped a lot and it worked! And sorry about the bad formatting I copied directly from SQL view and I'm pretty new to access so I didn't know how to format.

The reformatted code is missing a bracket at the end, however i still get the missing operator error in query expression '[ID] = '. Still can't find the error

Hello all, UPDATE TblInvoice SET TblInvoice.VCTBatch = DLookUp("[VCT Year]","[VCTBatch]","[Number] =" & 1) & "-" & DLookUp("[Increment]","[VCTBatch]","[Number] =" & 1) WHERE (TblInvoice.RecipientID IN (SELECT TOP 20 TblInvoice.RecipientID FROM TblInvoice WHERE TblInvoice.VCTBatch IS NULL AND...