第10行是出错代码
Dim ab As New ADODB.Connection
Dim dn As New ADODB.Recordset
Private Sub Command1_Click()
If Text1.Text = 0.25 Then
Dim bs As String
ab.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Administrator\Desktop\法兰GB文献\VB数据库练习\97版库\非金属软垫片1.mdb"
ab.Open
MsgBox ("连接成功")
bs = "select * from 非金属软垫片0,25 where DN = '" & Val(Text2.Text) & "'"
dn.Open bs '出错代码是这一行
Text4.Text = dn.Fields(D3)
End If
dn.Close '关闭记录集对象
Set dn = Nothing '释放内存
ab.Close '关闭数据库对象
Set ab = Nothing '释放内存
End Sub