Dim TIM As Integer
Dim mydb As Database
Dim myrs As Recordset
Dim sql As String
Private Sub Form_Activate()
  Set mydb = Workspaces(0).OpenDatabase(App.Path & "\kfgl.mdb") '打開數據庫
  sql = "select 操作員 from qxsz"
  Set myrs = mydb.OpenRecordset(sql)
  If myrs.EOF = False Then myrs.MoveLast
  If myrs.BOF = False Then myrs.MoveFirst
  For i = 0 To myrs.RecordCount - 1
      master.AddItem (myrs.Fields(0))
      myrs.MoveNext
  Next i
  If master.ListCount > 0 Then master.ListIndex = 0
  myrs.Close
  mydb.Close
  master.SetFocus
End Sub
Private Sub Cmdok_Click()              '確認操作員和密碼
  Dim MESSAGE As String
  If master.Text <> "" Then
     Set mydb = Workspaces(0).OpenDatabase(App.Path & "\kfgl.mdb")
     Set myrs = mydb.OpenRecordset("qxsz", dbOpenDynaset)
     myrs.FindFirst "操作員 = " + Chr(34) + master.Text + Chr(34) + ""   ' 查找操作員
     If myrs.NoMatch Then                                     '沒查到記錄
        MsgBox ("無此操作員！")
       Else
        If password.Text = myrs.Fields("密碼") Then               '確認密碼
           MsgBox "系統登陸成功！"                         '系統登錄成功
         Else
           If TIM = 3 Then
              MESSAGE = MsgBox("密碼輸入錯誤,請向系統管理員查詢!", 0, "")
              If MESSAGE = vbOK Then End
           End If
           MsgBox ("密碼錯誤,請重新輸入密碼!")
           TIM = TIM + 1                             '密碼輸入錯誤次數
           password.SetFocus
        End If
     End If
  End If
End Sub
Private Sub master_KeyDown(KeyCode As Integer, Shift As Integer)  '回車換行
  If KeyCode = vbKeyReturn Then
     password.SetFocus
  End If
End Sub
Private Sub password_KeyDown(KeyCode As Integer, Shift As Integer)
  If KeyCode = vbKeyReturn Then
     Cmdok.Visible = True
     Cmdok.SetFocus
  End If
  If KeyCode = vbKeyDown Then
     Cmdok.Visible = True
     Cmdok.SetFocus
  End If
  If KeyCode = vbKeyUp Then
     master.SetFocus
  End If
End Sub
Private Sub Cmdexit_Click()
  End
End Sub