dim rs as data1.recordsetprivate sub form_load()
if rs.recordcoun>0 then
rs.movefirst
end if
end sub 这样怎么老是报错呢?????为什么???怎么解决!!!
if rs.recordcoun>0 then
rs.movefirst
end if
end sub 这样怎么老是报错呢?????为什么???怎么解决!!!
你首先要打开数据库,如你上面的情况,应该是在form_load()里建立和数据库的连接.
Option Explicit
Public mDbs As Database
Public mWrk As WorkspacePrivate Sub Form_Load()
Dim mRst As Recordset
Set mWrk = CreateWorkspace("", "admin", "", dbUseJet)
Set mDbs = mWrk.OpenDatabase(App.Path & "\db1.mdb")
Set mRst = mDbs.OpenRecordset("Select * From Table1", dbOpenDynaset, dbDenyWrite)
Do While Not mRst.EOF
MsgBox mRst.Field(0)
mRst.MoveNext
Loop
mRst.Close
Set mRst = Nothing
End Sub
Option Explicit
Public mDbs As Database
Public mWrk As WorkspacePrivate Sub Form_Load()
Dim mRst As Recordset
Set mWrk = CreateWorkspace("", "admin", "", dbUseJet)
Set mDbs = mWrk.OpenDatabase(App.Path & "\db1.mdb")
Set mRst = mDbs.OpenRecordset("Select * From Table1", dbOpenDynaset, dbDenyWrite)
Do While Not mRst.EOF
MsgBox mRst.Field(0)
mRst.MoveNext
Loop
mRst.Close
Set mRst = Nothing
End SubPrivate Sub Command1_Click()
MsgBox mRst.RecordCount '也是RecordCount属性
End Sub
Option Explicit
Public mDbs As Database
Public mWrk As Workspace
Dim mRst As RecordsetPrivate Sub Form_Load()
Set mWrk = CreateWorkspace("", "admin", "", dbUseJet)
Set mDbs = mWrk.OpenDatabase(App.Path & "\db1.mdb")
Set mRst = mDbs.OpenRecordset("Select * From Table1", dbOpenDynaset, dbDenyWrite)
MsgBox mRst.RecordCount '也是RecordCount属性
Do While Not mRst.EOF
MsgBox mRst.Field(0)
mRst.MoveNext
Loop
mRst.Close
Set mRst = Nothing
End Sub