Jan 10, 2002 #1 case81 Programmer Jan 10, 2002 23 IE hey guys, im getting a syntax error on this update statement: strUpdate = "UPDATE teams SET day='yes' WHERE tid=" & teamid rsteams.open strupdate, dbcon any ideas? im confused, thanks
hey guys, im getting a syntax error on this update statement: strUpdate = "UPDATE teams SET day='yes' WHERE tid=" & teamid rsteams.open strupdate, dbcon any ideas? im confused, thanks
Jan 13, 2002 #2 gigsvoo Programmer Aug 24, 2001 18 MY strUpdate = "UPDATE teams SET day='yes' WHERE tid='" & teamid & "'" rsteams.open strupdate, dbcon Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo Upvote 0 Downvote
strUpdate = "UPDATE teams SET day='yes' WHERE tid='" & teamid & "'" rsteams.open strupdate, dbcon Thanks Neo http://communities.msn.com.my/VisualBasicwithNeo