CODEWITHSUNDEEP
ms-accessvba
Chrislaar123
Chrislaar123

Reputation: 321

Insert Into Code throws an error

I am using this code to insert 4 textboxes of data into a table. 

CurrentDb.Execute = "INSERT INTO tbl_machineheader(Line No, Description, Service Interval, Type) values ( '" & Me.Combo3 & "', '" & Me.Text1 & "', '" & Me.Text6 & "', '" & Me.Text12 & "')"

However it doesn't seem to work and I can't figure out why.

Upvotes: 1

Views: 79

Answers (1)

parakmiakos
parakmiakos

Reputation: 3020

That "=" character is wrong:

CurrentDb.Execute **=** "INSERT INTO tbl_machineheader(Line No, Description, Service Interval, Type) values ( '" & Me.Combo3 & "', '" & Me.Text1 & "', '" & Me.Text6 & "', '" & Me.Text12 & "')"

Also you should use square brackets for your column names. The correct syntax is as follows:

CurrentDb.Execute "INSERT INTO tbl_machineheader([Line No], [Description], [Service Interval], [Type]) values ( '" & Me.Combo3 & "', '" & Me.Text1 & "', '" & Me.Text6 & "', '" & Me.Text12 & "')"

Upvotes: 1

Related Questions