Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.Open "driver={Microsoft Access Driver (*.mdb)};pwd=mima;dbq=" & App.Path & "\db1.mdb"
rs.Open "select * from 3", conn, adOpenDynamic, adLockOptimisticrs
rs.AddNew
rs!姓名 = "xxxxxxx"
rs!性别 = "ssssss"
rs.Update
MsgBox "yes"
End Sub
运行后报错:实时错误"91"
对象变量或with块变量未设置
请问究竟该怎么办?求求各位大虾
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
conn.Open "driver={Microsoft Access Driver (*.mdb)};pwd=mima;dbq=" & App.Path & "\db1.mdb"
rs.Open "select * from 3", conn, adOpenDynamic, adLockOptimisticrs
rs.AddNew
rs!姓名 = "xxxxxxx"
rs!性别 = "ssssss"
rs.Update
MsgBox "yes"
End Sub
运行后报错:实时错误"91"
对象变量或with块变量未设置
请问究竟该怎么办?求求各位大虾
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货