Isaac
Lifelong Learner
- Local time
- Today, 03:23
- Joined
- Mar 14, 2017
- Messages
- 10,928
The question was, whether it was a date-column.Yes FD_Date is a column in tblFD
The question was, whether it was a date-column.Yes FD_Date is a column in tblFD
There is a screenshot and table structurewhat is the error?
dd.mm.yyyy. hh:mm:ss
6/27/2020 1:40 pm
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.Ok, then I think the problem might be with the date value from that unbound textbox.
I know there are many date formats out there, so it might just be that I am unfamiliar, but:does not look like any acceptable date format that I've ever seen. Try entering the date in the unbound textbox asCode:dd.mm.yyyy. hh:mm:ss
and then run your code and see what happens.Code:6/27/2020 1:40 pm
Thank you very much for your effort. I will try to implement to my DB. Will post feedback.updated my sample.
it will load the records from tblFD.
Actually I just looked closer at your error that you posted the screenshot.
Looks like you forgot to add the second #
Copy the code that I had given you exactly.
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.Looks good.
Did you look at the error message you posted? In the error message, it shows an insert value without the second # symbol.
The code you just posted looks good.
Yes I have checked three times and code has both # but error still occur.
I did but error is still there.Hmm, odd. You could try adding a space after the word value and see if that helps. There must be something else going on that I can't see.
I have tried your solution and if I select the yesterday date or any other date even present date I get an error.updated my sample.
it will load the records from tblFD.
Thanks I will try and post feedbackAttached is a database where I have the exact same table, same table column, same textbox, same command button and click event code as you do (minus the DoCmd.RunCommand acCmdSaveRecord, since you have stated that your code errs before that line, and my form isn't bound).
The code works fine.
Thus, something else is going on that I can't see.
There is a screenshot to get picture what I am trying to achieve.I have tried your solution and if I select the yesterday date or any other date even present date I get an error.
There is a screenshot to get picture what I am trying to achieve.Attached is a database where I have the exact same table, same table column, same textbox, same command button and click event code as you do (minus the DoCmd.RunCommand acCmdSaveRecord, since you have stated that your code errs before that line, and my form isn't bound).
The code works fine.
Thus, something else is going on that I can't see.
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 insert a date to get results only for that date. I have added =[Enter date] into criteria but I do not get any record. There is a screenshot of my query and results without criteriai hope this fixed the issue of your Date Regional setting.