SQL INSERT INTO -runtime error 3134

[jik_ff]

Sorry if this is a repeat post, but it seems that my other post (yesterday) disappeared...

in anycase, a recap. I am trying to add a record to an ODBC linked table on my SQL database. Looking on line, it sounds that using SQL INSERT INTO is the best way to go with this. Problem is I am getting an error 3134. I looked around for an hour or so, as there are various causes for this error, but none seemed to point to what I may be doing wrong. I have though tried to adopt the what has been told to others. here is the code (and commented out old code):

Please Login or Register  to view this content.

a few questions on this as well. Here I listed off all the fields and (tried) to throw data into all of them. Is it possible to just populate one field and the rest would be null? (in this case all fields need to be populated)

[Norie]

I think it's just a syntax problem, probably caused by a typo.

Try replacing (( before LocCode with (.

[jik_ff]

Crap... Well ok, got that out. Too much copy pasting I guess. Ok. So that is no longer the error, but now I am getting 3061, Too few Parameters. Expected 1. on the same CurrentDB.Execute strSQL line.

I think it has to do with how I am trying to get my variable data into the SQL string. Specificall this line:

strSQL = strSQL & "(newStr, 'Address1', 'Address2', 'City', 'StateProv', 'PostalZip', 'PhoneNo', 'FaxNo')"


newStr is a variable, where as the other items are text. Do I have to format it specifically with a variable (that is a string)?


EDIT: I know I am on the right track, if I change the newStr to text (putting 's around it) it works... Just need the right syntax for this...

[Norie]

To incorporate the variable in the SQL try this.

Please Login or Register  to view this content.

By the way, a good way to test the SQL is to print it to the immediate window like this.

Please Login or Register  to view this content.

You can the copy what's been output, paste it in the SQL view of a query and try to execute it.

If the syntax is right you should get a warning about changing/updating records and the option to cancel.

[jik_ff]

Awsome. Thanks for the tip. I new it had something to do with the & symbols...