rs已包含所有符合条件的记录了,只是你没有遍历RS读出来。 Dim rs As New Recordset sql = "select * from tb Where 姓别='女'" rs.Open sql, conn, 1, 3 do while not rs.eof msgbox rs("姓名") loop
rs已经有全部的纪录了,你用的时候再提取出来. Dim rs As New Recordset sql = "select * from tb Where 姓别='女'" rs.Open sql, conn, 1, 3 debup.print rs.recordcount
For i=1 to rs.recordcount msgbox rs("姓名") rs.movenext next i
Dim rs As New Recordset
sql = "select * from tb Where 姓别='女'"
rs.Open sql, conn, 1, 3
do while not rs.eof
msgbox rs("姓名")
loop
Dim rs As New Recordset
sql = "select * from tb Where 姓别='女'"
rs.Open sql, conn, 1, 3
debup.print rs.recordcount
msgbox rs("姓名")
rs.movenext
next i