Data1.Recordset.FindFirst "外卡号='" & Text1(0).Text & " '"If Data1.Recordset.NoMatch = False Then
Command2.Enabled = False
Text1(0).Enabled = False
Next iElse
MsgBox ("账号输入错误,请重新输入")
Text1(0).Enabled = True
Text1(0).Text = ""
Command2.Enabled = TrueEnd If请问一下高手,为什么系统提示第一句有错误呢?
Command2.Enabled = False
Text1(0).Enabled = False
Next iElse
MsgBox ("账号输入错误,请重新输入")
Text1(0).Enabled = True
Text1(0).Text = ""
Command2.Enabled = TrueEnd If请问一下高手,为什么系统提示第一句有错误呢?
Data1.Recordset.FindFirst "外卡号 =" & Chr(39) & Text1(0).Text & Chr(39)
If Not Data1.Recordset.NoMatch Then
MsgBox........
下面这段代码也不行(数据库应该都连好了,dataname和recordsource都设置好了)。
Private Sub Command2_Click()
Dim final As Integer, Flag As Integer
Flag = 1Data1.Recordset.MoveLast
final = Data1.Recordset.RecordCount
Data1.Recordset.MoveFirstFor i = 1 To final
If Data1.Recordset.Fields("外卡号") = Text1(0).Text Then
Flag = 0
Exit For
Else
Data1.Recordset.MoveNext
End If
Next iIf Flag = 0 Then
Command2.Enabled = False1
Text1(0).Enabled = False
Command3.Enabled = True
For i = 0 To 2
Command1(i).Enabled = True
Next iElse
MsgBox ("账号输入错误,请重新输入")
Text1(0).Enabled = True
Text1(0).Text = ""
Command2.Enabled = True
For i = 0 To 5
Text2(i).Text = ""
Next i
For j = 0 To 2
Text3(j).Text = ""
Next jEnd If
End Sub