asked on
From security workgroup to login form in MS Access
hi,
I've got this little challenge this week.
I do have a MS Access built in 2003 using security workgroup. There is a function called "displayRights" with the following attribute
Public Function displayRights (userName As String) As Boolean
displayRights = GetUserBoolValue(userName,
End Function.
This is used to get the logged in username from that Workgroup and determine if he can access the price tags in other forms where VBA calls this variable.
What I would like to do is to create the same global variable (instead of changing the whole vba on each form.
I have create a login form, that calls a table where is myUser and myPassword. In the same table there is a field where I do specifiy (0 or -1) if the logged in user has right to access price tags.
The question is How can I store this login information so I can call it every time a form is opened and make sure the proper right is applied.
I've got this little challenge this week.
I do have a MS Access built in 2003 using security workgroup. There is a function called "displayRights" with the following attribute
Public Function displayRights (userName As String) As Boolean
displayRights = GetUserBoolValue(userName,
End Function.
This is used to get the logged in username from that Workgroup and determine if he can access the price tags in other forms where VBA calls this variable.
What I would like to do is to create the same global variable (instead of changing the whole vba on each form.
I have create a login form, that calls a table where is myUser and myPassword. In the same table there is a field where I do specifiy (0 or -1) if the logged in user has right to access price tags.
The question is How can I store this login information so I can call it every time a form is opened and make sure the proper right is applied.
Microsoft AccessMicrosoft ApplicationsMicrosoft SQL Server
Last Comment
Scott McDaniel (EE MVE )
ASKER
THanks for your advise,
I will try to be more explicit.
In fact, I WAS using "User Level Security" ando NOT anymore since I have created a seperate table where I do store username and passwords as well as "displayRights" (field)
I just want to be able to display certain controls depending if "displayRights" is checked or not based on the logged in user.
I would like to explain it in a more simple english, but my french prevent me to do so ! :-)
My apologies ;)
I will try to be more explicit.
In fact, I WAS using "User Level Security" ando NOT anymore since I have created a seperate table where I do store username and passwords as well as "displayRights" (field)
I just want to be able to display certain controls depending if "displayRights" is checked or not based on the logged in user.
I would like to explain it in a more simple english, but my french prevent me to do so ! :-)
My apologies ;)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
And what if I already have another form set to start when the app is launched ?
Just open frmHidden in that form's Open or Load event. However, if you have a login mechanism, it's easiest to open frmHidden when the user credentials have been validated.
I don't really understand what you're asking. You can call the "displayRights" function from anywhere in the project, assuming it's stored in a Standard Module. You'd use it something like this:
If displayRights("YourUserNam
'/ do something here
Else
MsgBox "You don't have permission to open this form"
End If
If you're asking how to "store login information" then, again, I don't really understand. If you have a User table, then you could simply include a boolean field named IsLoggedIn, and set that value to True whenever someone logs in. This can be troublesome at times - for example, if the program crashes, you'd have to reset that field to False for all users in order to start back fresh.
If all you want to do is just store the UserName of the person who logged in, then the simplest way to do that is with a hidden form. Add a textbox to that form named "txUser", and set the value of that textbox when the user successfully logs in. You can then refer to that textbox as needed:
If Forms("YourHiddenForm").tx
'/ do something here
End If