Parameters too few !!!!!!!! 1

[lars7]

Hi there,

I'm getting a too few parameters (with or without the brackets) message with this code:

Dim strSQL1 As String

strSQL1 = "INSERT INTO copytblGameScores ( GPlayerId, GGameNo, GScore1, GScore2 )" & _
"SELECT [forms]![frmmainform]![text5] AS QId, tblTempFixtureSheet.[No], tblTempFixtureSheet.Score1, tblTempFixtureSheet.Score2 " & _
"FROM tblTempFixtureSheet INNER JOIN tblfixtures ON tblTempFixtureSheet.[No] = tblfixtures.GameNo "

CurrentDb.Execute strSQL1, dbFailOnError

can anyone see why.

 

[Eupher]

lars7,

Try this:

strSQL1 = "INSERT INTO copytblGameScores ( GPlayerId, GGameNo, GScore1, GScore2 ) " & _
"SELECT '" & [forms]![frmmainform]![text5] & "' AS QId, tblTempFixtureSheet.[No], tblTempFixtureSheet.Score1, tblTempFixtureSheet.Score2 " & _
"FROM tblTempFixtureSheet INNER JOIN tblfixtures ON tblTempFixtureSheet.[No] = tblfixtures.GameNo "

HTH,

Ken S.

 

[lars7]

Thanks Eupher that worked great.