Computethis
IS-IT--Management
I need to password protect a specific form in order to keep general users from gaining access to the form. Is there a simple solution to this ????
Thanks,
Mitch
Thanks,
Mitch
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Password protect specifc form 2
- Thread starter Computethis
- Start date
- Status
-
2
- #2
Are you using Access security I.E. logging in as Mitch?
If so in the on open event of your form (in Visual Basic),
something like this would work:
Private Sub Form_Open(Cancel As Integer)
On Error GoTo ErrFO
If CurrentUser()<> "Mitch" Then
MsgBox "Permission denied.", vbCritical, "Security Check."
Cancel = True
End If
ExitFO:
Exit Sub
ErrFO:
MsgBox Err.Description, vbInformation, "Form Open Error."
Resume ExitFO
End Sub
Bingo! Gord
ghubbell@total.net
If so in the on open event of your form (in Visual Basic),
something like this would work:
Private Sub Form_Open(Cancel As Integer)
On Error GoTo ErrFO
If CurrentUser()<> "Mitch" Then
MsgBox "Permission denied.", vbCritical, "Security Check."
Cancel = True
End If
ExitFO:
Exit Sub
ErrFO:
MsgBox Err.Description, vbInformation, "Form Open Error."
Resume ExitFO
End Sub
Bingo! Gord
ghubbell@total.net
- Status
Similar threads
