Hi all, got a puzzler. The code below inserts records into a connected Access table. problem is, when I look at the table, the date is 1899!
SQL = "Insert Into tblTransaction (TransactionNumber,UserID,SellDate) Values (" & intTransaction & "," & intUser & "," & Format(Now, "Short Date") & ");"
Anyone got any ideas as to where I'm going wrong? In the Access table the field is set to Date() by default. i could leave this but how do I go about the Insert statement? Surely if I specifiy the field to be inserted then I have to provide a value for it?
Thoughts please
Cheers, Lol
SQL = "Insert Into tblTransaction (TransactionNumber,UserID,SellDate) Values (" & intTransaction & "," & intUser & "," & Format(Now, "Short Date") & ");"
Anyone got any ideas as to where I'm going wrong? In the Access table the field is set to Date() by default. i could leave this but how do I go about the Insert statement? Surely if I specifiy the field to be inserted then I have to provide a value for it?
Thoughts please

Cheers, Lol
