Hi
try removing the single quotes from around the  non-string values
and make sure that the Now() function does have single quotes, which 
it appears you have already done.


hope this helps

Nigel				  

> -----Original Message-----
> From:	mmignot@m... [SMTP:mmignot@m...]
> Sent:	Friday, August 17, 2001 12:56 AM
> To:	professional vb
> Subject:	[pro_vb] Insert Syntax Error
> 
> Hi,
> I am getting an Syntax Error in the following INSERT INTO statement:
> 
> sqlINS = "INSERT INTO dbo_InvoiceLog(" & _
>          " TimeStamp," & _
>          " InvoiceNbr," & _
>          " CustNbr," & _
>          " CompanyName," & _
>          " PurchOrdNbr," & _
>          " BegDt," & _
>          " EndDt," & _
>          " TotAmt," & _
>          " CurrSym," & _
>          " DtPaid)" & _
>          " VALUES" & _
>          " (" & _
>          " '" & Now & "'," & _
>          " '" & Insert_InvNbr & "'," & _
>          " '" & Insert_CustNbr & "'," & _
>          " '" & Insert_CompanyName & "'," & _
>          " '" & Insert_PurchOrdNbr & "'," & _
>          " '" & Insert_BegDt & "'," & _
>          " '" & Insert_EndDt & "'," & _
>          " '" & Insert_TotAmt & "'," & _
>          " '" & Insert_CurrSym & "'," & _
>          " '" & Insert_DtPaid & "');"
>          myDB.Execute sqlINS, dbFailOnError
> 
> Is it possible there is something wrong with the "timestamp" field? 
> 
> Any suggestions would be greatly appreciated!!
> 
> MM :)