Hello,
I thought of a possible way to solve the problem of the annoying msg box that appears when a user tries to open a form when the administrator has not granted permission. (The problem with the message box is that the user has the option of clicking help and I don't want this)
Could I use VB code to say something like:
If CurrentUser = (available usernames that do have permissions) Then
DoCmd.OpenForm "Client Information Main Info Form", acNormal
Exit Sub
End If
MsgBox "You do not have permission to open this form!", vbOK, "Tennis Center Business Manager 2007"
Do you forsee this as a solution?
Thanks for your input!
Rob
I thought of a possible way to solve the problem of the annoying msg box that appears when a user tries to open a form when the administrator has not granted permission. (The problem with the message box is that the user has the option of clicking help and I don't want this)
Could I use VB code to say something like:
If CurrentUser = (available usernames that do have permissions) Then
DoCmd.OpenForm "Client Information Main Info Form", acNormal
Exit Sub
End If
MsgBox "You do not have permission to open this form!", vbOK, "Tennis Center Business Manager 2007"
Do you forsee this as a solution?
Thanks for your input!
Rob
