查询(在线等)
有三个文本方框:text1,text2,text3
一个数据库含以下字段:会员名字,会员卡号,会员地址
我想进行三个方框的或查询!(既可以用会员名字查询,或会员卡号,或两者结合,或三个结合查询)
Dim cnn1 As ADODB.Connection
Dim rst1 As ADODB.Recordset
Dim strcnn As String
strcnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\project\公司\db2.mdb;Persist Security Info=False"
Set cnn1 = New ADODB.Connection
Set rst1 = New ADODB.Recordset
cnn1.Open strcnn
Private Sub Command1_Click()
'怎么进行三个方框的或查询啊?
end sub