小第我想写一个跳出提示信息的程序(数据库中有多少条记录)程序一部分如下:Set rs = New ADODB.Recordset rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open "select * from CWMB ", conn, adOpenDynamic, adLockReadOnly
(像:) MsgBox "发现数据库中有" & rs.RecordCount, vbInformation, "提示:"
但是这样是不行的请问一下该怎么写啊,拜托,在线等待!!!
rs.LockType = adLockReadOnly
rs.Open "select * from CWMB ", conn, adOpenDynamic, adLockReadOnly
(像:) MsgBox "发现数据库中有" & rs.RecordCount, vbInformation, "提示:"
但是这样是不行的请问一下该怎么写啊,拜托,在线等待!!!
Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.LockType = adLockReadOnly
rs.Open "select * from CWMB ", conn, adOpenDynamic, adLockReadOnly
rs.movelast
MsgBox "发现数据库中有" & str(rs.RecordCount()), vbInformation, "提示:"
用adOpenStatic
Dim Rs As New ADODB.Recordset CN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\NWIND.MDB;Persist Security Info=False"
CN.Open Rs.CursorLocation = adUseClient
Rs.Open "select * from CWMB", CN, adOpenDynamic, adLockReadOnly MsgBox "发现数据库中有" & str(rs.RecordCount()), vbInformation, "提示:"