INSERT INTO using a variable / syntax error 2

[swtrader]

I get an "Object Required" error on the following code --

Have tried numerous alternatives -- nothing works. Am just trying to learn how to insert a variable into the table... ?? Thanks.

very new to VBA

=====================
...... this is in a module

Private Sub PutTheValueIntoTheTable()

Dim mySQL As String
Dim TestThingy

TestThingy = "This is the test data -- one more time."

'MsgBox " " & TestThingy

mySQL = "INSERT INTO tblTestTable (TestTextData) VALUES ('" & TestThingy.Value & "')"

DoCmd.RunSQL mySQL

End Sub

 

[RobertT687]

You don't need the .Value property.
Just use

 "INSERT INTO tblTestTable (TestTextData) VALUES ('" & TestThingy & "')"

Also, you should give the variable TestThingy a data type like
Dim TestThingy As String
rather than let it default to a Variant type.

 

[swtrader]

That did it! wasted a couple of hours on that one. Thanks.