Hi I am currently building a project for my final desirtation and and i've finished everything. However, I wanted to have a multi-user log in with privileges, so for example the Administrator can access everything, where as the rest of the staff can only access what is necessary to their use.
At the moment, I have a log in page, which i have done a statement. Like the following:
Username.SetFocus
If Username = "David" And Password = "paper" Then
MsgBox "Access Granted"
MsgBox "Welcome To Bulbul Corporation"
DoCmd.Close
DoCmd.OpenForm "frmSwitchboard"
Else
MsgBox "Please re-enter your Username and Password."
End If
I know I have to use tables so that I look in there which would be easier, but don't know how to do it myself.
However, does anyone know exactly what I mean, and how to do it, it will be appreciated a lot by myself.
At the moment, I have a log in page, which i have done a statement. Like the following:
Username.SetFocus
If Username = "David" And Password = "paper" Then
MsgBox "Access Granted"
MsgBox "Welcome To Bulbul Corporation"
DoCmd.Close
DoCmd.OpenForm "frmSwitchboard"
Else
MsgBox "Please re-enter your Username and Password."
End If
I know I have to use tables so that I look in there which would be easier, but don't know how to do it myself.
However, does anyone know exactly what I mean, and how to do it, it will be appreciated a lot by myself.
