1,451
社区成员
发帖
与我相关
我的任务
分享
Dim sql As String
Dim Cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vbworks.mdb"
sql = "Select * From duocanshu"
rs.Open sql, Cn, 1, 3
Data1.Recordset.AddNew
Data1.Recordset.Fields("测试时间") = Text17.Text
Data1.Recordset.Fields("测试地点") = Text1.Text
Data1.Recordset.Fields("项目1") = Text8.Text
Data1.Recordset.Fields("项目2") = Text16.Text
Data1.Recordset.Fields("项目3") = Text9.Text
Data1.Recordset.Fields("项目4") = Text10.Text
Data1.Recordset.Fields("项目5") = Text13.Text
Data1.Recordset.Fields("项目6") = Text15.Text
Data1.Recordset.Fields("项目7") = Text3.Text
Data1.Recordset.Fields("项目8") = Text2.Text
Data1.UpdateRecord
rs.Close
Cn.Close
Dim sql As String
Dim Cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\vbworks.mdb"
sql = "Select * From duocanshu"
rs.Open sql, Cn, 1, 3
rs.AddNew
rs.Fields("测试时间") = Text17.Text
rs.Fields("测试地点") = Text1.Text
rs.Fields("项目1") = Text8.Text
rs.Fields("项目2") = Text16.Text
rs.Fields("项目3") = Text9.Text
rs.Fields("项目4") = Text10.Text
rs.Fields("项目5") = Text13.Text
rs.Fields("项目6") = Text15.Text
rs.Fields("项目7") = Text3.Text
rs.Fields("项目8") = Text2.Text
rs.Update
rs.Close
Cn.Close