Search results

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.

Thank you for your solution but it is not working in my case. I have all ID numbers and other beneficiaries data in tblFD and every day when I open frmFD present date is set to unbound box. I would need to save that date for each ID number from unbound box which is after stored in Archive tblFD...

Thank you very much will try it when come form Leave

There is table structure and thank you very much because you helped me a lot in the past.

I get an error CurrentDb.Execute strSQL when I press Add_Date button

Right I need to create a log for every ID for each day. Every day there is three meals, breakfast, lunch and dinner. I wrote a VBA code for a button on click event to append date but it is not working. Private Sub cmdAdd_Date_Click() Dim strSQL As String strSQL = "INSERT INTO Food_Distribution...