docmd.runsql - error 438 - object doesnt support this property or method

[DanielR]

Trying to run and insert statement using:
DoCmd.RunSQL insertSQL

I did msgbox insertSQL:
"INSERT INTO Notes ([Project ID], Status, Comment, [User Name])
VALUES (5, 'In Progress', 'This is a test', 'dr'); "

Not sure why I am getting this error?

 

[Ranman256]

It seems legal. (is notes the table name?)
put it in a query and run it.
Try to use queries instead of sql. (for just that reason)

 

[DanielR]

Yes, "Notes" is the table name.
Your suggesting to use an update query instead of sql statements?

 

[DanielR]

I created an Append query. How do I pass data from my form to the query:
DoCmd.OpenQuery "qryAppendNotes" ....

 

[DanielR]

I tried to do:
DoCmd.OpenQuery insertSQL
where insert SQL is:
"INSERT INTO Notes ([Project ID], Status, Comment, [User Name])
VALUES (5, 'In Progress', 'This is a test', 'dr'); "
Still get the same error?

 

[DanielR]

I can run the sql code in the query and I get no error messages

 

[isladogs]

I tried to do:
DoCmd.OpenQuery insertSQL
where insert SQL is:
"INSERT INTO Notes ([Project ID], Status, Comment, [User Name])
VALUES (5, 'In Progress', 'This is a test', 'dr'); "
Still get the same error?

DoCmd.OpenQuery should be followed by the name of a query, not a SQL statement

Your code should be

DoCmd.RunSQL insertSQL

Or

CurrentDb.Execute insertSQL

Also have you defined insertSQL as a string?

 

[DanielR]

Not sure if it helped...haven’t tested it yet.
Thank you for the assistance.
It is appreciated.