Hello,
I am having problems, I need to insert values from my form in a date function and when it's insert into my tables it gives me time value instead of a date. Before I insert the values I format the date value I format the date into MM/DD/YYYY
Code:
strdate = Format(Me.txtEMPVACDate, "MM/DD/YYYY")
strINSERT = "INSERT INTO TBLEMPVAC values (" & Me.txtEMPVACID.value & ", " & Me.txtEMPID.value & "," & Me.cboVACID.value & "," & strdate & ")"
DoCmd.RunSQL strINSERT
Can anyone see what I am doing wrong in the statement above to help me?
Thank you,
Happy New Year