Manage users permissions in access (English)

start file - no code
drive.google.com/open?id=1YBB...
end file - code
drive.google.com/open?id=1oqs...

[@bossoftwareandtechnologies8731]

Excellent design, Very Intelligent Logic, very helpful video such like really professional peoples

[@ristantosky]

Beautiful login design , thanks mate

[@yanick3643]

you are amazing my bro

[@cybertjc]

Thank you so much but still having a little trouble. Would it be possible to put the finished product up for download?

[@AdelMobarakTr]

Thank you Farouk pasha

[@AlaIsmail2012]

this is a very basic approach, I hope you can develop it more with RBAC approach... there is lots of drawback for the security approach you are using... anyway thanks for your video, please continue.

[@ihsangadi6162]

Thanks for such nice videos, i loved your videos.
I have question for multiuser login system.
1. Created user registration form, any user can register by his own. By New user. Once his registration is complete, he can login.
2. Bu for this I want user ID (login ID) for login purpose but not the actual name of any user. So I created query to create "User Name"(login ID) by using user First and last name
3. Now I want use that "User name" /"login ID for the login form.
Dont know how to connect that, because my user name is existing in query (userExtended) but not in User Table. So that user can login with loginID.

[@yocopop]

Thank you for the tutorial and nice backgroung. one question, how to have to the "Remember me" functionality? thanks for your help

[@askfarouk]

Thanks for your great question
th-cam.com/video/oPpv12s_gsM/w-d-xo.html

[@joelast8503]

Hi Ahmed! For some reason when I debug using your code, the login form is not recognized "MS Access cannot find the referenced form 'FormLogin' Help... Thanks.

[@joelast8503]

No. I just copied you procedures and all else work but the point of the click on the button (departments) since it cannot find the login page. Thanks.

[@joelast8503]

Thanks. I already have a database that I'm using. Best, Joe

[@abdurraheem2457]

Sir, run time error ..you can't assign a value to this object?

[@askfarouk]

Hi. I am not sure why you get the error. Try to download the sample and compare your code to it.

[@j.johnson6028]

Hello I am unable to get through with the Id part of your code, you have to different boxes for it and then the unbound one you use as ID but when I assign mines to the empty one it is not pulling the imformation and also I am getting a yellow line can you incite me please and thank you.
also can you direct me to your the login video please and thank you?

[@askfarouk]

I have login code in Arabic video, I will list the link here and with the video you will find copy of the code

[@askfarouk]

th-cam.com/video/oPpv12s_gsM/w-d-xo.html

[@j.johnson6028]

@@askfarouk Hello I am a little embrassed I have given your code another shot and I have gotten through with the login and I am going through to the other steps now thank you.

[@askfarouk]

th-cam.com/video/fi2-1GG5paY/w-d-xo.html

[@askfarouk]

@@j.johnson6028 that is great, I am very happy it works.

[@j.johnson6028]

Hello I have a new error where microsoft is not recognising my loginForm, do you have any tips on what I should do? The form name is also correct
This is my Code
If Form!LoginScreen!HealthStatusForm = 0 Then
MsgBox "Access Denied"
Else
DoCmd.OpenForm "Health Status Form"
End If
microsoft is telling me it can't find the expression loginscreen do you have any incite?

[@askfarouk]

If forms not form
Try

[@j.johnson6028]

@@askfarouk I did same thing not recognising the login form

[@askfarouk]

@@j.johnson6028 email me the database [e-mail]
no commitment but i will try