Great job But the problem is any passwords is working with any users

@EdcelleJohnGulfan

2 жыл бұрын

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

@EdcelleJohnGulfan

2 жыл бұрын

Check out my lastest comment

@emito634

2 жыл бұрын

@@EdcelleJohnGulfan I tried to fix it and it keeps giving the same error.

@EdcelleJohnGulfan

2 жыл бұрын

@@emito634 what's the error message?

@erickbarahona3515

2 жыл бұрын

@@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

@EdcelleJohnGulfan

2 жыл бұрын

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!!

@EdcelleJohnGulfan

2 жыл бұрын

Thanks Webber. Highly appreciated.

Lot of Thanks... Very Helpful Porductive Exercise....

@EdcelleJohnGulfan

Жыл бұрын

Thanks for watching

Hello po. Salamat sa mga videos. Marami po akong natutunan.

@EdcelleJohnGulfan

2 жыл бұрын

Welcome

Your content is very good. It helps me a lot! Thank you.

@EdcelleJohnGulfan

6 ай бұрын

I'm glad it helps.

Thanks for the coding man! Let me go and get this raise

@EdcelleJohnGulfan

Жыл бұрын

Thanks for watching.

Nice video your sir

clean👍👏👏👏👏

@EdcelleJohnGulfan

Жыл бұрын

Thanks Khalid

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?

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.

THANK YOU!!!!!! I have been looking for a way to seperate user access without using AD. Thank you!!!!!!

@EdcelleJohnGulfan

2 ай бұрын

You're welcome!

@jbraun3043

2 ай бұрын

@@EdcelleJohnGulfan The login function is working perfectly. How do I log the user out and drop them to the login screen?

Nie job We want you sir, to make videos on STUDENTS RESULTS COMPLITION MANAGENT SYSTEM

@EdcelleJohnGulfan

9 ай бұрын

We'll try to make. Something like a grading system.

Thank you

@EdcelleJohnGulfan

2 жыл бұрын

Thanks for watching

Very helpful

@EdcelleJohnGulfan

3 ай бұрын

Thank you so much for watching.

And the navigation interface

Hi ...Please explain the ATM program required at my university

thanks bro i cant understane

@EdcelleJohnGulfan

4 ай бұрын

Study from the very basic.

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

@EdcelleJohnGulfan

Жыл бұрын

if login credentials is correct, just add this code. Docmd.Close

@EdcelleJohnGulfan

Жыл бұрын

Thanks for asking.

@ChrisWedam

Жыл бұрын

@@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.

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.

Please how did you create the admin control

@EdcelleJohnGulfan

8 ай бұрын

I'll create a video soon.

you can do a lesson on how to make barcodes in access?

@EdcelleJohnGulfan

8 ай бұрын

Thanks for the idea.

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

@felixbukachi1822

8 ай бұрын

Thanks man

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

Great video, thanks. I learn right now Access and I have some problems organizing this, how can I connect you?

@EdcelleJohnGulfan

2 жыл бұрын

eduardogulfan@gmail.com

@EdcelleJohnGulfan

2 жыл бұрын

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.

@EdcelleJohnGulfan

9 ай бұрын

Thanks for watching my videos! By the way, have you tried the Anchoring?

@ptzzycool

9 ай бұрын

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?

@EdcelleJohnGulfan

Жыл бұрын

Email me at eduardogulfan@gmail.com

@adammorra3813

Жыл бұрын

@@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

@EdcelleJohnGulfan

Жыл бұрын

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.

@EdcelleJohnGulfan

Жыл бұрын

I will create a video for this soon.

@NixieBurton

2 ай бұрын

I see this is about a year old. Have you created this video yet?

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)'.

@MorounofoluSefiu

2 ай бұрын

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.

@EdcelleJohnGulfan

2 жыл бұрын

Next week, i will upload a video on how to secure your database.

@NguyenTam-zl2tk

2 жыл бұрын

@@EdcelleJohnGulfan Thank you!

@newman3059

Жыл бұрын

@@EdcelleJohnGulfan can u post it pls bro

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?

@EdcelleJohnGulfan

2 ай бұрын

Yes really possible. I will make a video soon

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?

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

@EdcelleJohnGulfan

3 ай бұрын

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. kzread.info/dash/bejne/mIKGvNyih6bgfco.html

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

I have a data when i run it my computer freezes sir plz tell me the solution

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

@EdcelleJohnGulfan

2 жыл бұрын

Baka parehong "Please enter the correct username" sa coding mo. Dapat ang isa ay Please enter the correct password".

How to make a load form for database in access

It can be use other password with same usename:)

@EdcelleJohnGulfan

Жыл бұрын

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

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.

@EdcelleJohnGulfan

10 ай бұрын

Here's the separate video.

Good tutorial but all passwords must be with hash and encryption on database

@EdcelleJohnGulfan

2 жыл бұрын

Not all the times. Encrypted password is very easy to open.

@johnch6476

2 жыл бұрын

@@EdcelleJohnGulfan is the best way to add passwords with cryptographic salt

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

@EdcelleJohnGulfan

5 ай бұрын

Wrong spelling or the FIelds you are writing is NOT EXIST.

Sir how to create case sensitive for password po?

Could I have a copy of your database to practice with?

@EdcelleJohnGulfan

2 жыл бұрын

Visit this link. kzread.info/head/PLxBRM3hoV3nPdnE3yKTztDD4bPmgOScJQ 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

@EdcelleJohnGulfan

8 ай бұрын

Use this. kzread.info/dash/bejne/p2Sgx8OKZLOnddY.html

Hello sir. What version po ng ms access ginagamit nyo?

@EdcelleJohnGulfan

2 ай бұрын

2019 and 365

Hello sir. Whould it be possible that if the current password is active, it will be detected amg denied user?

@EdcelleJohnGulfan

Жыл бұрын

What do you mean sir, active on network?

How to protect from distribution? accde ?

@EdcelleJohnGulfan

11 ай бұрын

Thanks for the question. I'll create a video about that.

@kensimba7868

29 күн бұрын

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

@EdcelleJohnGulfan

Жыл бұрын

Books din kunting KZread.

@migomotovlog

Жыл бұрын

@@EdcelleJohnGulfan galing sir ahh dami ko natutunan..

@EdcelleJohnGulfan

Жыл бұрын

Salamat sa panonood sir.

What about the admin control form? You didn't teach how to make it

@EdcelleJohnGulfan

4 ай бұрын

Open access option using vba: kzread.infoR492MuN4Bt0?feature=share

@EdcelleJohnGulfan

4 ай бұрын

Hide / unhide menu: kzread.info_p1Ddn6DsjU?feature=share

i want to add url to login buton but i can't know the code

@EdcelleJohnGulfan

Жыл бұрын

Elaborate your needs maybe I can help you.

Pano po mahihide yung mismong Ms access kapag naload na yung mainform

@EdcelleJohnGulfan

Ай бұрын

kzread.info/dash/bejne/m6mHubCYpbnUfJs.html

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

@EdcelleJohnGulfan

Жыл бұрын

I wrote the correct code in the previous comments. Kindly find and copy it.

debug problem in putting the security portion solution please

@EdcelleJohnGulfan

6 ай бұрын

What's the error message?

I would like to give you a small project

@EdcelleJohnGulfan

7 ай бұрын

Email me @ eduardogulfan@gmail.com

Kuyaaaa having syntax error sa If Userlevel is = 1 Then 🥺

@EdcelleJohnGulfan

2 жыл бұрын

Ano ang error?

@neetusingh2579

2 жыл бұрын

@@EdcelleJohnGulfan navigation form pop up kuya hindi nawawala si log in form after access granted kahit nakalabas na si navigation pop up

@EdcelleJohnGulfan

2 жыл бұрын

Before sa code na message box for ACCESS GRANTED, lagyan mo ng Docmd.close

@neetusingh2579

2 жыл бұрын

@@EdcelleJohnGulfan got it kuya! Gawa ka rin video kung pano mag pop up yong log ins pag open palang ng database app hehe

@EdcelleJohnGulfan

2 жыл бұрын

Baka pareho nitong nasa video. Auto execute: kzread.info/dash/bejne/ZXiOuNSJn8--Zdo.html

Use less

@EdcelleJohnGulfan

2 жыл бұрын

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 & "'")

@EdcelleJohnGulfan

2 жыл бұрын

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.

@Eev0L

Жыл бұрын

@@EdcelleJohnGulfan same problem here