Syntax Error With VBA and Date/Time

[pparadis]

Any help would be appreciated. I'm trying to keep a log of activity in a database. I have a text box for users to document their activity and I'm trying to time and date stamp each entry, but I keep getting a syntax error. I'm pretty sure it's something I'm doing wrong with date and time. I'm using the Date() and Time() function to get a long time and short date. Here's some code:

Sql = "Insert into Modifications(Day, Time, Descrip)
Values( '" & Date() & "' , '" & Time() & "' , '" & Me.description & "');"

db.Execute (Sql)

I think I need some #'s but I haven't been able to figure out where.

Thanks.

 

[jebry]

Hi!

Instead of the single quotes around your date and time use the # sign. Alternatively, you can set the default value in the table itself for these two fields to date() and time() so that every time a new record is created the current date and time is entered.

Jeff Bridgham