access的表MailInfo中有mailAddress和linkMan两个字段 添加信息的界面有txtMailAddress.Text和txtName.Text两个变量, 输入要改的内容,当txtMailAddress.Text和mailAddress相同时,txtName.Text赋值给linkMan,但是表里有多条记录的mailAddress相同,怎样把他们的linkMan都修改呢? 我现在只能修改第一条记录,后面mailAddress相同的修改不了! 满意答案 用SQL语句可以一次性搞定,比如: set conn=createobject("adodb.connection") conn.open "....." '这里连接数据库的过程省略了,自己改 conn.execute "update MailInfo set linkMan='" & txtName.Text & "' where mailAddress='" & txtMailAddress.Text & "'" conn.close set conn=nothing 也可以找出所有txtMailAddress.Text和mailAddress相同的记录,然后逐条修改: set conn=createobject("adodb.connection") conn.open "....." '这里连接数据库的过程省略了,自己改 set rs=createobject("adodb.recordset") rs.open "select * from MailInfo where mailAddress='" & txtMailAddress.Text & "'",conn,1,3 do until rs.eof rs("linkMan")=txtName.Text rs.update rs.movenext loop rs.close set rs=nothing conn.close set conn=nothing |
|