Recent content by saledo2000

I've done it. In the code I did not set date format for ThisDate wich is in function set as Date. strDate = Format(ThisDate, "yyyy\/mm\/dd")

I have tried your solution for date format fix and is not working. The first day I took your solution was working perfectly but today does not work. I am access beginner and would need your help. My date format is DDMMYYY. Time zone in Windows settings is UTC + 01:00. I have set date format in...

Thank you very much arnelgp. I have included your solution in my DB and it works. You are the man. I wish to buy you a beer. I have another question if you can help. I have UNION query of multiple Entry and Exit date and I have made another query out of UNION query. But I cannot put criteria to...

There is a screenshot to get picture what I am trying to achieve.

There is a screenshot to get picture what I am trying to achieve.

Thanks I will try and post feedback

I have tried your solution and if I select the yesterday date or any other date even present date I get an error.

I did but error is still there.

Yes I have checked three times and code has both # but error still occur. By the way thank you for helping me to solve this trivial problem but I am new in Access world. Learning every day hard and hope to get where you are guys.

There is a code with your suggestion. Private Sub cmdAdd_Date_Click() Dim strSQL As String strSQL = "INSERT INTO Food_Distribution (FD_Date) VALUES(#" & Me.txtUnboundDate & "#)" CurrentDb.Execute strSQL DoCmd.RunCommand acCmdSaveRecord End Sub Error on screenshot does not show last #. I have...

Thank you very much for your effort. I will try to implement to my DB. Will post feedback.

My date has format Short date dd.mm.yyyy on the form in unbound box and in the tblFD field as well e.g. 26.06.2020.

There is a screenshot and table structure

Yes FD_Date is a column in tblFD.

Error happened because I added # # in strSQL = "INSERT INTO Food_Distribution (FD_Date) VALUES (#" & Me.txtUnboundDate & "#)". In my original code is strSQL = "INSERT INTO Food_Distribution (FD_Date) VALUES('" & Me.txtUnboundDate & "')" but nothing happens when I press cmdAdd_Date button.