Solved Too few parameters

[ClaraBarton]

I've been over and over this:

Public Sub AddJunctionRecord(LocID As Long, ItemID As Long)
      Dim strSQl As String
10    strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _
                "VALUES (LocID, ItemID);"
20        CurrentDb.Execute strSQl, dbFailOnError
End Sub

Returns the error: too few parameters; expected 2
On break LocID returns the value of 4 and ItemID returns the value of 376.
The junction table only has 2 fields besides the autonumber.
What is it talking about?

 

[CJ_London]

You need to separate the values

strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _ "VALUES (“ & LocID & “,” & ItemID & “)”

 

[ClaraBarton]

Even if they're actual field names and not variables? The Insert statement isn't that way. Is it right?

 

[ClaraBarton]

WELL! You are so right! Thank you so much!

 

[ClaraBarton]

Wait... Now it says too few parameters; expected 4. Is it playing with me?

Public Sub AddJunctionRecord(LocID As Long, ItemID As Long)
      Dim strSQl As String
10    strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _
                "VALUES (“ & LocID & “,” & ItemID & “);"
20        CurrentDb.Execute strSQl, dbFailOnError
End Sub

 

[MajP]

My guess is you copied from a word processor because you have Smart Quotes arround LocID and ItemID not straight quotations. Need to get rid of Smart Quotes.

 

[ClaraBarton]

ahh... if anyone cares, here's what works:

Public Sub AddJunctionRecord(LocID As Long, ItemID As Long)
      Dim strSQl As String
10    strSQl = "INSERT INTO tblLocItem (fLocID, fItemID) " & _
                "VALUES(" & LocID & ", " & ItemID & ");"
20        CurrentDb.Execute strSQl, dbFailOnError
End Sub

 

[ClaraBarton]

Really? Who knew! Thank you

 

[MajP]

Suffix Help

I have a report that show what place a player finished at, this text box will show 1, 2, 3 and I would like it to show 1st, 2nd, 3rd. Does anyone have an idea on how to.

www.access-programmers.co.uk

 

[cheekybuddha]

ahh... if anyone cares, here's what works:

Are fields fLocID and fItemID really strings, or are they actually a numeric datatype?

 

[ClaraBarton]

Aargh! They're numbers but the sql didn't error! I've fixed it.

 

[CJ_London]

Even if they're actual field names and not variables? The Insert statement isn't that way. Is it right?

always helps if you debug.print your sqlstr before executing it. If still not obvious what the problem is, copy the string from the immediate window and paste to a new query and try to execute it from there