P
pubdude2003 via AccessMonster.com
Been a tough week for bugs. This code looks good but fails. Any insights
would be appreciated
Dim strQuote As String
Dim str As String
Dim strQuote3 As Long
str = "INSERT INTO 2007TourneyResults([week2]) VALUES " _
& strQuote3 & " WHERE [playerid] = '" & strQuote & "'"
Debug.Print str
CurrentDb.Execute str, dbFailOnError
table 2007TourneyResults
field week2 long integer
field playerid text
here's the string it's returning
INSERT INTO 2007TourneyResults([week2]) VALUES 630000 WHERE [playerid] =
'00/65/67/'
would be appreciated
Dim strQuote As String
Dim str As String
Dim strQuote3 As Long
str = "INSERT INTO 2007TourneyResults([week2]) VALUES " _
& strQuote3 & " WHERE [playerid] = '" & strQuote & "'"
Debug.Print str
CurrentDb.Execute str, dbFailOnError
table 2007TourneyResults
field week2 long integer
field playerid text
here's the string it's returning
INSERT INTO 2007TourneyResults([week2]) VALUES 630000 WHERE [playerid] =
'00/65/67/'