Run time erro 3075 INSERT INTO SQL
Posted on 2007-08-09
I have a bunch of textboxes on my form which are not visible but are populated by my listboxes. I'm trying to INSERT INTO the values from the textboxes into my table. I'm keep getting this error 3075. Can you anyone take a loot at it. My fields are listed below:
All are text except for txtSTOCKQTY, txtSELLPRICE, and txtCONVERSION. These are integers.
Here is what I have so far. Any help would be awesome.
Dim strSQL As String
strSQL = "Insert Into tblProductLocation "
strSQL = strSQL & "Values ('" & txtNotAtLocation & ",'" & txtPN & "'" & txtPartNumber & "','" & txtDESCRIPTION & "' '" & txtSTOCKUOM & "'"
strSQL = strSQL & " , " & txtSTOCKQTY & ",'" & txtSELLUOM & "'," & txtSELLPRICE & "," & txtconversion & ")"