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...
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 & "#)"
Error on screenshot does not show last #. I have...
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.