源码如下:Option Explicit Public OK As Boolean Dim miCount As IntegerPrivate Sub Form_Load() OK = False miCount = 0 End SubPrivate Sub cmdOK_Click() Dim txtSQL As String Dim mrc As ADODB.Recordset Dim Msgtext As String UserName = "" If Trim(txtUserName.Text = "") Then MsgBox "用户名不得空缺,请重新输入!", vbOKOnly + vbExclamation, "警告" txtUserName.SetFocus Else txtSQL = "select * from user_Info where user_ID='" & txtUserName.Text & "'" Set mrc = executeSQL(txtSQL, Msgtext) If mrc.EOF = True Then MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告" txtUserName.SetFocus Else If Trim(mrc.Fields(1)) = Trim(txtPassword.Text) Then OK = True mrc.Close Me.Hide UserName = Trim(txtUserName.Text) Else MsgBox "输入密码不对,请重新输入!", vbOKOnly + vbExclamation, "警告" txtPassword.SetFocus txtPassword.Text = "" End If End If End If miCount = miCount + 1 If miCount = 3 Then Me.Hide End If Exit Sub End Sub
Public OK As Boolean
Dim miCount As IntegerPrivate Sub Form_Load()
OK = False
miCount = 0
End SubPrivate Sub cmdOK_Click()
Dim txtSQL As String
Dim mrc As ADODB.Recordset
Dim Msgtext As String
UserName = ""
If Trim(txtUserName.Text = "") Then
MsgBox "用户名不得空缺,请重新输入!", vbOKOnly + vbExclamation, "警告"
txtUserName.SetFocus
Else
txtSQL = "select * from user_Info where user_ID='" & txtUserName.Text & "'"
Set mrc = executeSQL(txtSQL, Msgtext)
If mrc.EOF = True Then
MsgBox "没有这个用户,请重新输入用户名!", vbOKOnly + vbExclamation, "警告"
txtUserName.SetFocus
Else
If Trim(mrc.Fields(1)) = Trim(txtPassword.Text) Then
OK = True
mrc.Close
Me.Hide
UserName = Trim(txtUserName.Text)
Else
MsgBox "输入密码不对,请重新输入!", vbOKOnly + vbExclamation, "警告"
txtPassword.SetFocus
txtPassword.Text = ""
End If
End If
End If
miCount = miCount + 1
If miCount = 3 Then
Me.Hide
End If
Exit Sub
End Sub