I wish to enable more than one named user to access password protected
menu ie: Tom,Dick and Harry rather than JUST Tom.
Can I do this with Case Select...doesn' t seem work for me.
Assistance much appreciated.
Private Sub cmdOk_Click()
Dim blnEnter As Boolean
Static intCount As Integer
blnEnter = False
intCount = intCount + 1
lblAttempt.Capt ion = intCount
Select Case txtUsername
Case "Tom"
If txtPassword = "nkp12345" Then
blnEnter = True
End If
End Select
If blnEnter = True Then
Unload Me
frmMenu.Show
Else
If intCount >= 3 Then
MsgBox "you have exceeded your 3 attempts"
Unload Me
End If
End If
End Sub
menu ie: Tom,Dick and Harry rather than JUST Tom.
Can I do this with Case Select...doesn' t seem work for me.
Assistance much appreciated.
Private Sub cmdOk_Click()
Dim blnEnter As Boolean
Static intCount As Integer
blnEnter = False
intCount = intCount + 1
lblAttempt.Capt ion = intCount
Select Case txtUsername
Case "Tom"
If txtPassword = "nkp12345" Then
blnEnter = True
End If
End Select
If blnEnter = True Then
Unload Me
frmMenu.Show
Else
If intCount >= 3 Then
MsgBox "you have exceeded your 3 attempts"
Unload Me
End If
End If
End Sub
Comment