7,763
社区成员
发帖
与我相关
我的任务
分享
Private Sub Command1_Click()
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\beng.mdb;Persist Security Info=False"
.CommandType = adCmdText
Dim L As Single, H As Single
L = CSng(Text1.Text) ''流量
H = CSng(Text2.Text) ''扬程
.RecordSource = "select * from beng where liuq>=" & L * 0.9 & " and liuq<=" & L * 1.1 & " and yangch>=" & H * 0.9 & " and yangch<=" & H * 1.1
.Refresh
End With
End Sub
ps:对于Adodc1不要设置任何属性。