Private Sub Command5_Click()
Dim find As String
Dim rssearch As ADODB.Recordset
Dim con2 As ADODB.Connection
find = "select * from xinxi where 会员卡号='" & Text3.Text & "';"
Set con2 = New ADODB.Connection
con2.Provider = "Microsoft.Jet.OLEDB.4.0"
con2.Open "man.mdb"
Set rssearch = New ADODB.Recordset
rssearch.Open find, con2, adOpenDynamic
If rssearch.EOF And rssearch.BOF Then MsgBox "没有", vbOKOnly, "stop!!"
Text1.Text = rssearch!会员卡号
Text2.Text = rssearch!会员姓名
End Sub请问哪有问题啊
Dim find As String
Dim rssearch As ADODB.Recordset
Dim con2 As ADODB.Connection
find = "select * from xinxi where 会员卡号='" & Text3.Text & "';"
Set con2 = New ADODB.Connection
con2.Provider = "Microsoft.Jet.OLEDB.4.0"
con2.Open "man.mdb"
Set rssearch = New ADODB.Recordset
rssearch.Open find, con2, adOpenDynamic
If rssearch.EOF And rssearch.BOF Then MsgBox "没有", vbOKOnly, "stop!!"
Text1.Text = rssearch!会员卡号
Text2.Text = rssearch!会员姓名
End Sub请问哪有问题啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货