A1VBCode Forums

Insert with Where clause statement


http://a1vbcode.com/vbforums/Topic30433.aspx

By mjshort88 - 6/12/2011

Hello



I've been trying to get this SQL statement working for ages now and came across this website!



It's probably really simple but any help would be great.



"INSERT INTO Images (PicName) VALUES (" & TextBox1.Text & ") WHERE ImageID = " & Summary



I get an error message 'Missing ; at the end of SQL statement'



I'm using a Access database back end.



Thank you