Insert Date on the fly query 1

[Xenocide]

Hi I wanna insert that in my table

strSQL4 = "INSERT INTO Date850([Date], [IdEngagementA], [Depense]) " & _
"VALUES ('X','" & lst2.Value & "','" & txt2.Value & "') ;"

The first value, X, is suppose to be the date of the day.
Is there a way to get the date on the computer and insert it in the database with an insert like mine?

What should be the inputmask of the date date in the database? I used the short date one

 

[PHV]

strSQL4 = "INSERT INTO Date850([Date], [IdEngagementA], [Depense]) " & _
"VALUES (#" & Format(Date, "yyyy-mm-dd") & "#,'" & lst2.Value & "','" & txt2.Value & "') ;"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

thanks a lot

is there a way to do the same but in a Query instead of a onthefly one

 

[PHV]

Yes:
INSERT INTO Date850 ([Date], IdEngagementA, Depense)
VALUES (Date(), [Forms]![mainform name]![lst2], [Forms]![mainform name]![txt2])


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Xenocide]

Thanks PHV

it helped