有关Recordset如何使用问题?
点击次数:23 次 发布日期:2008-11-27 18:41:08 作者:源代码网
|
源代码网推荐
源代码网整理以下
在窗体中加了下面的一段代码:
dim recName as recordset
recName=currentdb.openrecordset("t1")
"t1是数据库中的一张表
"问题出在这,它说类型不对
.
.
我的问题是我上面代码有什么问题?如何将一张表传递给一个recordset?
---------------------------------------------------------------
Give a example as
Private Sub LockTest_Click()
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("Customers", dbOpenTable, dbDenyWrite)
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing
DBEngine.Idle dbFreeLocks
Set db = CurrentDb
Set rs = db.OpenRecordset("Customers", dbOpenTable, dbDenyWrite)
rs.Close
db.Close
Set db = Nothing
Set rs = Nothing
DBEngine.Idle dbFreeLocks
End Sub
源代码网供稿. |