How to create Multi User LOGIN FORM in Ms Access With SECURITY LEVEL | Part-1
Vložit
- čas přidán 31. 12. 2021
- Part 2: • How to create Multi Us...
Part 3: • How to create Multi Us...
Check box type: • DEMO: Set Permission C...
👍 Please Like comment and share to support this channel
czcams.com/users/EdcelleJohnGulf...
A cup of coffee is always welcome : www.paypal.com/paypalme/eduar...
⏱️ Timestamps:
13:10 Insert Security Level
Please Like and Subscribe for more video 🙏
#microsoftaccess
#microsoftaccesstutorial
#mstutorial
#loginform
KEYWORD:
How to create login form in microsoft access,
Login form in microsoft access with credentials,
How to create login form in microsoft access with security label,
How to appear username in dashboard,
How to create a temporary login in microsoft access,
Microsoft access login form tutorial,
microsoft access tutorial for beginners,
microsoft access database tutorial,
microsoft access 2019, - Krátké a kreslené filmy
Great job
But the problem is any passwords is working with any users
Nice. I forgot to add lines for it.
Just find this lines.
Below the ELSE,
TempVarUsername.......
UserLevel......
TempPass.....
Id......
'Insert this code
IF ME.PASSWORD TEMPPASS THEN,
MSGBOX "INCORRECT PASSWORD",VBINFORMATION," LOGIN DENIED"
ME.USERNAME = ""
ME.PASSWORD =""
ME.USERNAME.SETFOCUS
ELSE
Check out my lastest comment
@@EdcelleJohnGulfan I tried to fix it and it keeps giving the same error.
@@emito634 what's the error message?
@@EdcelleJohnGulfan Thank you! this video was so helpful!
I also came across the same problem, can you provide the solution without temppass? I'd like to keep the code for part one only. thank you again!
Another very informative video, looking forward to the next part, I'm learning so much from your videos
Thank you much.
Awesome tutorial man, everything worked great. I would recommend everyone watching part two as well!!
I also reached out to Edcelle John Gulfan and he quickly replied to my email and helped me with my problem. I am excited to see future videos he produces!!
Thanks Webber. Highly appreciated.
Lot of Thanks... Very Helpful Porductive Exercise....
Thanks for watching
Hello po. Salamat sa mga videos. Marami po akong natutunan.
Welcome
Your content is very good. It helps me a lot! Thank you.
I'm glad it helps.
Thanks for the coding man! Let me go and get this raise
Thanks for watching.
Nice video your sir
clean👍👏👏👏👏
Thanks Khalid
Incredibly hard to follow along at a low level when you're using similar field names with text field names, etc. Other than that, pretty good.
A very nice explanation for the login. Unfortunately, it doesn't work with what is the relationship between the tables user and security level? it seems to me to have at this point. can you get a sample from the database?
THANK YOU!!!!!! I have been looking for a way to seperate user access without using AD. Thank you!!!!!!
You're welcome!
@@EdcelleJohnGulfan The login function is working perfectly. How do I log the user out and drop them to the login screen?
Very helpful
Thank you so much for watching.
Nie job
We want you sir, to make videos on STUDENTS RESULTS COMPLITION MANAGENT SYSTEM
We'll try to make. Something like a grading system.
Thank you
Thanks for watching
Wonderful video. But please how do you close the form after login is successful. I mean how to close the login form after a successful login
if login credentials is correct, just add this code.
Docmd.Close
Thanks for asking.
@@EdcelleJohnGulfan Thank you
Thanks for the great work you do for us by posting videos that help us in some parts of database.
My issue is, how can I create a form the looks up like.
Someone's particulars of address
Having
country, 》Uganda, kenya, Tanzania
districts, 》districts under Uganda are Kampala, Jinja, Gulu, Arua
subcounties,》subcounties under Kampala are Nakawa, central, maki, Jinja etc
Parishes,》
Villages,》
I want something like a tree structure of a family.
I want to open a country then select a district in that country then under districts select a sub-county in that district, then under sub-counties select a parish in that sub-county then under parish select a village in that parish lastly in village the family.
thanks bro i cant understane
Study from the very basic.
Please how did you create the admin control
I'll create a video soon.
you can do a lesson on how to make barcodes in access?
Thanks for the idea.
hello sorry if I bother you, I'm following your tutorials on ms access and I'm finding them really very interesting and useful, I'm just asking you a favor could you send me the access file of the multi user login form, thanks in advance I'm waiting for your reply.
Best regards,
Filippo.
Hi ...Please explain the ATM program required at my university
Thanks a lot for the video, just want some help in the user level, when i write the code for the user level it will perform the action of opening any idea how to fix it
And the navigation interface
Great video, thanks.
I learn right now Access and I have some problems organizing this, how can I connect you?
eduardogulfan@gmail.com
Fb: Ed Peres Matugas Gulfan
Sir, thank you so much. I really like your tutorials. They are helping a lot. Your layouts look so fantastic and wish to design mine to look the same. However whenever I try to open them on different size monitors, they seem to fit well in some and in others, they don't. Is there a way to set the database forms so that they automatically adjust to fit well in any screen size? Thanks.
Thanks for watching my videos!
By the way, have you tried the Anchoring?
Thank you so much sir. I will try that.@@EdcelleJohnGulfan
I found this video to be very helpful
Thanks for all your hard work
Can you please let me know if I can get the access file you used in the video
If yes, where can I get it?
Email me at eduardogulfan@gmail.com
@@EdcelleJohnGulfan Why not just post it on a website so not everyone has to email you for the file?
hello, I followed your "how to create login for in Ms access till part 3. I created a main menu for users and it has report preview for login users to view reports concerning their book loans. Am challenged on how to makesure this report only opens the records of the logged member and not others member's records. Plz build on what you did in Part 3. thanks
Nice question.
Actually same concept with part 3.
But in your query ( data source of report) you must filter using the login Id or user id.
I will create a video for this soon.
I see this is about a year old. Have you created this video yet?
Sir pano po un, nag try ako ginaya ko po, pero Me nag pop up po na "Run-Time error '3075':
Syntax error in string in query expression 'Username=gfgt".
Ano po ibig sabihin nun?
Pano ko po un maayos?
Hey Edcelle, I watched this video and I was thinking about mine. Do you have a video on how to recover a password?
View the table using excel.
Is there a way to use this code to open a specific record on a subform within the navigation form? I set up my navigation form to have an employee directory where the user can see all other records. I also created a subform to show an employee skills matrix but I would like this form to filter and only show the record related to the current user logged in.
Is this possible?
Yes really possible.
I will make a video soon
When I log in, it doesn't go straight to the Navigation form (I created navigation form) it says it has a problem in security level
You videos have been so awesome!!!!! I have run into one problem only. I have created the "Username" and "Security Level" tables as you did. However, when i add the "Else userlevel" row i get this error when I try to login:
Run-time error '3075':
Syntax error (missing operator) in query expression '(Security Level)'.
this is the correct code
Dim UserLevel As Variant ' Changed to Variant type for flexibility
If IsNull(Me.Username) Then
MsgBox "Please enter the correct username.", vbInformation, "Username required"
Me.Username.SetFocus
Exit Sub
End If
If IsNull(Me.Password) Then
MsgBox "Please enter the correct password.", vbInformation, "Password required"
Me.Password.SetFocus
Exit Sub
End If
' Check if the username and password combination exists in the UserAccount table
If IsNull(DLookup("Username", "UserAccount", "Username='" & Me.Username & "'")) Or _
IsNull(DLookup("Password", "UserAccount", "Password='" & Me.Password & "'")) Then
MsgBox "Invalid username or password.", vbInformation, "Authentication Failed"
Me.Username = ""
Me.Password = ""
Me.Username.SetFocus
Exit Sub
End If
' Retrieve the user's security level from the UserAccount table
UserLevel = DLookup("[SecurityLevel]", "UserAccount", "Username='" & Me.Username & "'")
' Check if a valid security level was retrieved
If IsNull(UserLevel) Then
MsgBox "Error retrieving user's security level.", vbCritical, "Error"
Exit Sub
End If
' Use Select Case for clarity and flexibility
Select Case UserLevel
Case 1 ' User Level 1
MsgBox "Access Granted. You may proceed!", vbInformation, "Authentication Succeeded"
DoCmd.OpenForm "Home"
Case 2 ' User Level 2
DoCmd.OpenForm "Admin Controls"
Case Else ' Handle other user levels if needed
MsgBox "Unknown user level.", vbCritical, "Error"
End Select
End Sub
Very nice! Can you tell me how to prevent user access to view the content of the data tables? thank you.
Next week, i will upload a video on how to secure your database.
@@EdcelleJohnGulfan Thank you!
@@EdcelleJohnGulfan can u post it pls bro
Nice video po sir, can u try to log in po na Eduardo tas password 123. Makaka log in po sya baka may line of code ka po to trap na ganitong scenario. Thank u po
Sir may nakalimutan akong isang line jan. Ang mga password ay pwede magamit sa ibang users.
Panoorin mo ang link sa ibaba para ma-correct mo sir.
czcams.com/video/fNRZziWCzMg/video.html
I have a data when i run it my computer freezes sir plz tell me the solution
Hi sir, thank you for your efforts
I faced some issues during writing the code this is no setfocus when I tried to write and give error (method or data member not found)
Could you please help me and tell me the solution
Wrong spelling or the FIelds you are writing is NOT EXIST.
It can be use other password with same usename:)
I forgot to add lines for it.
Just find this lines.
Below the ELSE,
TempVarUsername.......
UserLevel......
TempPass.....
Id......
'Insert this code
IF ME.PASSWORD TEMPPASS THEN,
MSGBOX "INCORRECT PASSWORD",VBINFORMATION," LOGIN DENIED"
ME.USERNAME = ""
ME.PASSWORD =""
ME.USERNAME.SETFOCUS
ELSE
How to make a load form for database in access
Hi po. Bago lang po ako nag aaral ng Access sa youtube. Pinapanood ko po mga video ninyo. Ask ko lang po nilagay ko na ang first syntax and second syntax kaso kapag ni-run ko na kapag nilagay ko sa username box okay siya "Please enter the correct username" pero kapag nilagay ko sa password box ang lumalabas pareho sa user name "Please enter the correct username". Tama naman po ang syntax gaya ng nasa video ninyo. Ano po gagawin ko? Salamat
Baka parehong "Please enter the correct username" sa coding mo. Dapat ang isa ay Please enter the correct password".
Could I have a copy of your database to practice with?
Visit this link. czcams.com/play/PLxBRM3hoV3nPdnE3yKTztDD4bPmgOScJQ.html
My exercise file could be downloaded here.
i keep having problems with the security level, when I first open the login form it works well with no password or a password not in the table, however if the username is correct I can use any password in the table from the password field and it lets me in. why isn't the password associated with the username not working
Use this. czcams.com/video/u0leaQ4PAEs/video.html
Good tutorial but all passwords must be with hash and encryption on database
Not all the times. Encrypted password is very easy to open.
@@EdcelleJohnGulfan is the best way to add passwords with cryptographic salt
Excelente video, pero me he dado cuenta que la ingresar las contraseñas, no distingue mayusculas y minusculas. Osea si tengo la siguiente contraseña: AbCdE. El access le da igual si pones ABCDE o abcde. Entonces se convierte en una falla de seguridad porque no estaría realizando la validación exacta. Como se solucionaría esta vulnerabilidad.
Here's the separate video.
Sir how to create case sensitive for password po?
Hello sir.
Whould it be possible that if the current password is active, it will be detected amg denied user?
What do you mean sir, active on network?
Hello sir. What version po ng ms access ginagamit nyo?
2019 and 365
Here is complete code.
Please like, comment and share if possible to improve the algorithm of this video.
Thanks.
Private Sub Process_Click()
Dim UserLevel As Integer
Dim TempPass As String
Dim ID As Integer
Dim TempVarUsername As String
If IsNull(Me.UserName) Then
MsgBox "Please enter the correct USERNAME", vbInformation, "Username Required"
Me.UserName.SetFocus
ElseIf IsNull(Me.Password) Then
MsgBox "Please enter the correct PASSWORD", vbInformation, "Password Required"
Me.Password.SetFocus
Else
If (IsNull(DLookup("[UserName]", "UserAccount", "[UserName] ='" & Me.UserName.Value & "'"))) Or _
IsNull(DLookup("password", "UserAccount", "Password ='" & Me.Password.Value & "'")) Then
MsgBox "Incorrect Username or Password", vbInformation, "Login Denied"
Me.UserName = ""
Me.Password = ""
Me.UserName.SetFocus
Else
TempVarUsername = DLookup("[EmployeeName]", "UserAccount", "Username ='" & Me.UserName.Value & "'")
UserLevel = DLookup("[Security Level]", "UserAccount", "Username ='" & Me.UserName.Value & "'")
TempPass = DLookup("[Password]", "UserAccount", "Username ='" & Me.UserName.Value & "'")
ID = DLookup("[UserId]", "UserAccount", "Username ='" & Me.UserName.Value & "'")
If Me.Password TempPass Then
MsgBox "Incorrect Password", vbInformation, "Login Denied"
Me.UserName = ""
Me.Password = ""
Me.UserName.SetFocus
Else
DoCmd.Close
If (TempPass = "Password") Then
MsgBox "Please change your Password", vbInformation, "Password Change"
DoCmd.OpenForm "userAccount", , , "[UserId]=" & ID
Else
If UserLevel = 2 Then
MsgBox "Access Granted! You may proceed.", vbInformation, "Authentication Succeeded"
DoCmd.OpenForm "Navigation form"
ElseIf UserLevel = 1 Then
DoCmd.OpenForm "Admin Controls"
End If
End If
End If
End If
End If
End Sub
Thanks man
I really like your explaination but this accepts any password. can you work us through why it doesnt work and how to fix it. Thank you
I wrote the correct code in the previous comments. Kindly find and copy it.
How to protect from distribution? accde ?
Thanks for the question. I'll create a video about that.
A good question. I've just began creating database systems for businesses but am worried my customers may want to sell to other people who operate similar businesses.
San po kayo ng aral ng access programming
Books din kunting CZcams.
@@EdcelleJohnGulfan galing sir ahh dami ko natutunan..
Salamat sa panonood sir.
What about the admin control form? You didn't teach how to make it
Open access option using vba: czcams.com/users/shortsR492MuN4Bt0?feature=share
Hide / unhide menu: czcams.com/users/shorts_p1Ddn6DsjU?feature=share
I would like to give you a small project
Email me @ eduardogulfan@gmail.com
i want to add url to login buton but i can't know the code
Elaborate your needs maybe I can help you.
Pano po mahihide yung mismong Ms access kapag naload na yung mainform
czcams.com/video/iuSWN_uVnL8/video.html
debug problem in putting the security portion
solution please
What's the error message?
Kuyaaaa having syntax error sa If Userlevel is = 1 Then 🥺
Ano ang error?
@@EdcelleJohnGulfan navigation form pop up kuya hindi nawawala si log in form after access granted kahit nakalabas na si navigation pop up
Before sa code na message box for ACCESS GRANTED, lagyan mo ng Docmd.close
@@EdcelleJohnGulfan got it kuya! Gawa ka rin video kung pano mag pop up yong log ins pag open palang ng database app hehe
Baka pareho nitong nasa video.
Auto execute: czcams.com/video/3DZVrPolX5w/video.html
Use less
If you don't like my flowers then, stay out of my garden. By the way, thanks for watching Omar.
I am stuck getting errors on the following code:
Else
Userlevel = DLookup("[SecurityLevel]", "UserAccount", "Username='" & Me.UserName.Value & "'")
That's correct statement of Dlookup.
Have you type Dim Userlevel as Integer above your code? Or just check in your table maybe the USER LEVEL is one word only.
@@EdcelleJohnGulfan same problem here