• I am creating a new home page for this site, where the focus will be on directing people to the forums. If you would like to provide a testimonial, I would be most grateful. The thread where this is discussed can be found here: Seeking Testimonials Alternatively, just private message me.

Recent content by saledo2000

  1. S

    Solved Save date from unbound text box to table

    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")
  2. S

    Solved Save date from unbound text box to table

    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...
  3. S

    Solved Save date from unbound text box to table

    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...
  4. S

    Solved Save date from unbound text box to table

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

    Solved Save date from unbound text box to table

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

    Solved Save date from unbound text box to table

    Thanks I will try and post feedback
  7. S

    Solved Save date from unbound text box to table

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

    Solved Save date from unbound text box to table

    I did but error is still there.
  9. S

    Solved Save date from unbound text box to table

    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.
  10. S

    Solved Save date from unbound text box to table

    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...
  11. S

    Solved Save date from unbound text box to table

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

    Solved Save date from unbound text box to table

    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.
  13. S

    Solved Save date from unbound text box to table

    There is a screenshot and table structure
  14. S

    Solved Save date from unbound text box to table

    Yes FD_Date is a column in tblFD.
  15. S

    Solved Save date from unbound text box to table

    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.
Top Bottom