Dim conn As New ADODB.Connection
Dim rs As New ADODB.ConnectionPrivate Sub Command1_Click()
rs("入库日期") = Label9.CaptionEnd SubPrivate Sub Command2_Click()
男女鞋入库.Show
Me.Hide
End SubPrivate Sub Form_Load()
Dim sql As String
sql = "select * from [ctt]"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "/db1.mdb"
rs.Open sql, conn, adLockOptimistic
Label9.Caption = DateEnd Sub
提示的错误是在form的rs.Open sql, conn, adLockOptimistic这个语句上
Dim rs As New ADODB.ConnectionPrivate Sub Command1_Click()
rs("入库日期") = Label9.CaptionEnd SubPrivate Sub Command2_Click()
男女鞋入库.Show
Me.Hide
End SubPrivate Sub Form_Load()
Dim sql As String
sql = "select * from [ctt]"
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "/db1.mdb"
rs.Open sql, conn, adLockOptimistic
Label9.Caption = DateEnd Sub
提示的错误是在form的rs.Open sql, conn, adLockOptimistic这个语句上
rs.open sql,conn ,adOpenKeySet,adLockOptimistic
这个里面的adOpenKeySet,adLockOptimistic 是什么啊??是属性还是其他?谢谢
rs.open sql,conn ,3,2