将过程的参数定义为RecordSet型即可。
注意:要先将DAO引用进来。例:Sub PsDemo()
Dim objDB As Database
Dim objRs As Recordset
Set objDB = OpenDatabase("Test.MDB")
Set objRs = objDB.OpenRecordset("Select * From Test")
Call PsDemoSub(objRs)
objRS.Close
objDB.Close
End SubSub PsDemoSub(AobjRs As Recordset)
Debug.Print AobjRs.Fields("Name").Value
AobjRs.Edit
AobjRs.Fields("Name").Value = "John Smith"
AobjRs.Update
End Sub
注意:要先将DAO引用进来。例:Sub PsDemo()
Dim objDB As Database
Dim objRs As Recordset
Set objDB = OpenDatabase("Test.MDB")
Set objRs = objDB.OpenRecordset("Select * From Test")
Call PsDemoSub(objRs)
objRS.Close
objDB.Close
End SubSub PsDemoSub(AobjRs As Recordset)
Debug.Print AobjRs.Fields("Name").Value
AobjRs.Edit
AobjRs.Fields("Name").Value = "John Smith"
AobjRs.Update
End Sub
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货