Solved Update Date query not working in AccessVBA

[Pat Hartman]

I don't see any reason to embed this SQL in VBA. It is static so it will be fine as a querydef. If it is not working from VBA, then it has not been transferred correctly.

 

[Sodslaw]

if it was working, it would update it to 2nd November.

You are jumping all over the place, stop, take a breath . Provide the full vba code you are now actually using. And whilst you are at it, provide the recordsource to your form (or subform if that where your code is running). It may be you have the record locked

Great Advise
i added a new button to the form just to update the date and it seemd to do the trick.

really dont know why but noticed the debug print from this..

UPDATE TblOrderCustLink SET QuotePrintdate =#11/02/2022# WHERE OrderCustLinkID = 1;

to this...

UPDATE TblOrderCustLink SET QuotePrintdate = #2022-02-11# WHERE OrderCustLinkID = 1

and now working. I beleive, when trying those codes i deleted the sql exectution line at some point and the code i tried from then on didnt work. i can finally have a beer and start my weekend.

Thanks to everyone for your help and have a great weekend.

 

[Pat Hartman]

The first update statement sets the date to Nov, 11. However, as I said earlier,

UPDATE TblOrderCustLink SET QuotePrintdate = Date() WHERE OrderCustLinkID = 1;

would set the date to today's date.

 

[Gasman]

The first update statement sets the date to Nov, 11.

Nov 2nd?

 

[Pat Hartman]

Sorry Nov 2. Thanks.