Comments by edriso (Top 29 by date)

the error message is in the title! thankx for your help (it is solved but if don't mind have a look to the below code)
thanks

YESS, thank you very much , because a copy the code from another form i forgot this line, anyway it work fine now
can ask for your help with another one please.
the following code i have syntax error but i can't figure it out
<pre>
conn.Open()
cmd = New OleDbCommand("UPDATE core_skill SET crimping=?,cr_trainer=?,cr_doc=?,cr_date=?,soldering=?,so_trainer=?,so_doc=?,so_date=?,brazing=?,br_trainer=?,br_doc=?,br_date=?, where op_id=?", conn)
cmd.Parameters.AddWithValue("crimping", cr)
cmd.Parameters.AddWithValue("cr_trainer", TextBox6.Text.ToString)
cmd.Parameters.AddWithValue("cr_doc", TextBox3.Text)
cmd.Parameters.AddWithValue("cr_date", dd)
cmd.Parameters.AddWithValue("soldering", so)
cmd.Parameters.AddWithValue("so_trainer", TextBox7.Text.ToString)
cmd.Parameters.AddWithValue("so_doc", TextBox4.Text)
cmd.Parameters.AddWithValue("so_date", dd1)
cmd.Parameters.AddWithValue("brazing", br)
cmd.Parameters.AddWithValue("br_trainer", TextBox8.Text.ToString)
cmd.Parameters.AddWithValue("br_doc", TextBox5.Text)
cmd.Parameters.AddWithValue("br_date", dd2)
cmd.Parameters.AddWithValue("op_id", Integer.Parse(Label1.Text))
cmd.ExecuteNonQuery()
conn.Close()
</pre>

for some reason it works now thanks for you all

i have changed the column name and still gives the same error any idea why? please don't give up
thanks