VB中的数据保存到ACCESS的问题
Private Sub Text3_Change()
Dim Sql As String, S As String
S = Text4.Text
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\db1.mdb"
'请将路径换成你的数据库位置
Sql = "select * From 表1"
Rs.Open Sql, Conn, 1, 3
Rs.AddNew
Rs(0) = S
Rs.Update
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
End Sub
Private Sub Text4_Change()
Dim Sql As String, S As String
S = Text4.Text
Dim Conn As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\db1.mdb"
'请将路径换成你的数据库位置
Sql = "select * From 表1"
Rs.Open Sql, Conn, 1, 3
Rs.AddNew
Rs(1) = S
Rs.Update
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
End Sub
我要把TEXT3和TEXT4显示在同一记录中
这个代码哪有问题,他们不显示在同一记录里