运行环境:vb 6.0 + access 2003
代码所在位置 command1 里。dim x,y as Integer
x=记录总数if x<=115 then
exit if
else
y=x-115
movefirst
删除y条记录
end if请高手们将上面代码中的记录总数和删除y条记录,
修改成代码,并确认可以运行,谢谢!
代码所在位置 command1 里。dim x,y as Integer
x=记录总数if x<=115 then
exit if
else
y=x-115
movefirst
删除y条记录
end if请高手们将上面代码中的记录总数和删除y条记录,
修改成代码,并确认可以运行,谢谢!
For i = 1 To y
.Delete
.MoveNext
Next
x1 = .RecordCount运行结果:x1 = -1怎么才可以准确的计算出记录总数。
Dim rst As New ADODB.Recordset
cnn.CursorLocation = adUseClient
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"C:\Documents and Settings\Administrator\My Documents\" & _
"11.mdb;Persist Security Info=False"
Set rst = cnn.Execute("select * from itb1")
x1 = rst.RecordCount