Mar 13, 2002 #1 sugermama Technical User Oct 19, 2001 11 US Would like to know how to update an Access record with a test score based on the user id and password of the test taker. Thank you
Would like to know how to update an Access record with a test score based on the user id and password of the test taker. Thank you
Mar 14, 2002 #2 snowboardr Programmer Feb 22, 2002 1,401 PH 'open conn here.. StrSql = "UPDATE table_name SET userscore = value WHERE user_id=Idnumber AND password='mypassword'" Set rs = my_conn.execute(StrSql) 'excute it here.. Upvote 0 Downvote
'open conn here.. StrSql = "UPDATE table_name SET userscore = value WHERE user_id=Idnumber AND password='mypassword'" Set rs = my_conn.execute(StrSql) 'excute it here..