Now() function 1

[Watermelon]

Hi,

I'm using the Now() function in an Access module to try to insert the current date and time into a date/time field in one of my tables. Everytime I try to run the code I get a "Syntax error in Insert statement." Here's my code:
sql = "INSERT INTO IPOClientDetails(ClientID, Date,ContactMethod)VALUES(" & rsNewOrders!ClientID & "," & Now() & "," & """Email""" & &quot"

Does anyone have any idea what the problem is? Thanks for any help?
SGM

 

[DanJR]

hi there,

try putting a space between ) and VALUES....


sql = "INSERT INTO IPOClientDetails(ClientID, Date,ContactMethod) VALUES(" & rsNewOrders!ClientID & "," & Now() & "," & """Email""" & &quot"



Cheers,
Dan

 

[Watermelon]

Hi Dan,

Thanks for the suggestion. I tried that out. Unfortunately, I'm still getting the same message. I'm pretty sure the problem is the Now() field because I don't get the error message when I comment out this field. But, I still don't know exactly what that problem is.

Watermelon

 

[cmmrfrds]

The date literal must be surrounded by # or ' after it is resolved depending on the database being used.

sql = "INSERT INTO IPOClientDetails(ClientID, Date,ContactMethod)VALUES(" & rsNewOrders!ClientID & ", #" & Now() & "#, " & """Email""" & &quot"

 

[Watermelon]

Hi cmmrfds,

Thanks, bingo. That did it.

Watermelon