Insert query syntax error

[Bobnz]

Hi getting a syntax error with this query

strSQL = "INSERT INTO order"
    strSQL = strSQL + "(clientname, supplierid, productid, quantity, comment, dateordered  )"
    strSQL = strSQL + " values (" & Me!txtclientname & "," & Me!cmboven.Column(1) & ""
    strSQL = strSQL + " ," & Me!cmboven.Column(0) & ", " & Me!txtoquantity & ", " & Me!txtocomment & ", " & Me!txtoodate & " )"
    
    DoCmd.RunSQL strSQL

when I type in the following in the immediate window

?strSQL

it returns

INSERT INTO order(clientname, supplierid, productid, quantity, comment, dateordered  ) values (brown,2 ,2, 1, very nice, 9/11/2004 )

which looks ok to me???
no doubt something blindingly obvious, if someone
could point it out...

TIA

Bob

 

[PHV]

strSQL = "INSERT INTO order"
strSQL = strSQL + "(clientname, supplierid, productid, quantity, comment, dateordered )"
strSQL = strSQL + " values ([highlight]'[/highlight]" & Me!txtclientname & "[highlight]'[/highlight]," & Me!cmboven.Column(1) & ""
strSQL = strSQL + " ," & Me!cmboven.Column(0) & ", " & Me!txtoquantity & ", [highlight]'[/highlight]" & Me!txtocomment & "[highlight]'[/highlight], [highlight]#[/highlight]" & [highlight]Format([/highlight]Me!txtoodate [highlight], "m/dd/yyyy") & "#[/highlight] )"



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

 

[Bobnz]

Thanks for the reply but thats not it

Bob

 

[PHV]

When you paste the result of ? strSQL in a SQL code view pane of the query design window, what happen ?

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

 

[Bobnz]

Got it order must be a reserved word duh "order by"
once I put [order] evrything was fine.

thanks for the replies though.

Bob

 

[PHV]

evrything was fine
Without the addition of single quotes and #s ?

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

 

[Bobnz]

No I needed both single quotes and hash signs

thanks for that.

B