Login access

[princess12]

i have successfully created a login system



now the issues is

for example all users can see form A with a login button - it very complex system

but if user A logs in he could click a button to see the same form A but should not be able to see the login button on that form, because he logged in, therefore should be able to access other menu or forms that hes allowed to see.

in simple words there are multiple users but there are forms where both can see so if a user is logged in clicks form A then to go to their forms they have to go to login again , it messes the flow of the system.

i thought of splitting database but i am not sure, i havent done it before. i backed it up and tried it but i dont know how to do it. i want both users to see the same form, although one form should have more functionality.

also this database is not in the network or server. it only on local network

thanks hope i made sense please guide me the right way

p.s loggin in with correct access levels works it just preventing other users from using certain features on the form and ensuring they kept logged on and not off

[ranman256]

It's 1 or the other, is it on a network or not? You just said its on both.
DO split the db via the options in access. SPLIT db tool. It separates the tables from the code/objects.

as for the login, I have a tUsers table. In it, it has the userID, and their rights.
Once login authenticates, it opens main menu, gets rights, then enables/disables buttons for them to go to their forms.

[princess12]

no it not on the network. it on the computer desktop is what i meant, sorry for confusion.

i don't know if you understand me. you saying after login, disable buttons for user A but not user b by using access levels - i understand that but my issue is i want both users
in main menu to go to form A but they should not see the login button. since form A is also used by other users without loggin in.

in short i want to disable a button after loggin in on form a for users and show button only if not logged in. i do not want to disable the form. just the button

[princess12]

ok i found a solution

if form is loaded during the login session disable button else
if form is not loaded during the loggin session enable the button. thank you

[princess12]

well after playing with the system, it behaving funny, could someone please check the code and see if am doing something wrong

this is in the login section
If DLookup("AccessLevelType", "tblEmp", "AccessLevelID = 1 AND Username='" & Me.txtUserName & "'") > 0 Then
DoCmd.OpenForm "RMenu"
If CurrentProject.AllForms(formb).IsLoaded Then
Forms!formb.txtbox1.SetFocus
Forms!formb.cmdLogin.Visible = False
End If

If CurrentProject.AllForms(formb).IsLoaded Then
Forms!formb.cmdRMenu.Visible = True
End If

[Perceptus]

Have you tried just putting the code in the Form Load/Current event for the form in question? You could get rid of the "isloaded" checks then.

I would guess the issue is coming from the reference of your objects, can you enter the references into the Immediate window (Ctrl + G)? You can copy and paste the form statements into the immediate window to test if they work. Example, copy and paste

Forms!formb.txtbox1.visible = false

while you have the form open on your screen. if the reference was valid you would see it go away. debug debug debug!

[princess12]

i need the isloaded checks before i am trying to get two users to the same form after login, and on that page both users will have different form buttons links, for example one user will go to form c after loggin to that form and another user will go to form d. but without login user should be able to see the default form. so basically i went through it again implementing under login section

first two times works with different forms or controls ofcourse

when i put it the third time for a different form, it does not work at all, even the previous two form checks wont work

[princess12]

never mind, i fixed it, sorry for the trouble