56. Creating A Classic Login Form (Programming In Microsoft Access 2013) 🎓

[@ProgrammingMadeEZ]

Looking for DAILY content? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: kzbin.info/door/eXAUvo5xxDY_b-lSknPC1A

[@marcosrene4446]

I know im asking randomly but does anyone know of a trick to get back into an Instagram account?? I stupidly lost my account password. I would love any tricks you can offer me

[@kylernolan5402]

@Marcos Rene instablaster =)

[@marcosrene4446]

@Kyler Nolan I really appreciate your reply. I found the site thru google and Im trying it out atm. Seems to take quite some time so I will reply here later with my results.

[@marcosrene4446]

@Kyler Nolan It worked and I finally got access to my account again. Im so happy:D Thanks so much you saved my account :D

[@kylernolan5402]

@Marcos Rene Happy to help xD

[@kathleenstrecker4287]

This tutorial was AWESOME. I really appreciate how you explain WHY you're doing things as you're doing them. It's easy to follow and duplicate. THANK YOU!

[@junaidarif3363]

Great video, exceptional Just one issue In the login screen, even if the password field is empty it logs in the user, how can we stop this user must enter password to log in like i want to have a check that if txtpassword is empty it should not log in user and open the frmmain

[@adammcknight4881]

Hi. Excellent video and explanation. However, you need to add a piece of code for when the password textbox is empty. Add the in the following code above the second IF statement: If IsNull (Me.txtPassword) Then Me.lblWorongPass.Visible = True Me.txtPassword.SetFocus Exit Sub End If Then proceed with the remainder of the code. If this piece of code is left out the log in form will allow anyone who enters a valid username to access the database without knowing the valid password. Again, great video!

[@christopherlubinski9440]

Adam thank you very much for the help!

[@davidivens9477]

This is extremely helpful, and so well explained.. Thanks Steve. It worked first time for me on a charity database where data protection and confidentiality is very important. Great video. Great explanation!

[@zakwanshah7442]

lol, i had no idea what you were talking about for the entire length of this video, but i used the code and it worked, so i must have understood some of it, and that's all that matters, thanks.

[@ProgrammingMadeEZ]

I would recommend you watch the series in it's entirety then. You will gain much more knowledge about how Access can be useful for you.

[@MrAitch_]

I'm late to the party here but don't go telling the user if they have got the wrong username or password directly, just send a message that the login credentials are wrong. The way this particular bit of code works informs the 'Hacker' that they have broken the username and he/she/they can now concentrate on the password. So in your code check both username and password in the same pass through then output a message such as 'Incorrect Username/Password Pair' Hey Steve, nice helpful series you've put out here.

[@ProgrammingMadeEZ]

Thank you Mr Aitch! Thanks for watching.

[@Sameh_Abdel-Qawy]

Hi Steve! Perfectly explained and perfect code. Thanks a lot. But I got a small problem. When entering User Name without any password, it also opened. What can I do to solve it? Thanks a lot.

[@lisaneabauer4410]

Hi there, I'm a novice but followed your tutorial and worked first time.... a huge thank you... :)

[@michis6379]

Hi Steve! This is very helpful- simple to follow and you explain the process so well to non-programmers like me. Thank you so much for making my life easier! Kudos! I will watch your other videos as I build my database.

[@ProgrammingMadeEZ]

michie i0113 I am so glad you are enjoying the series.

[@johnkamilmalabunga6785]

This guy make my Job Easier Thanks bro.. Just follow the Steps Carefully 110% it will Work

[@mazeem27n]

It's working with wrong password but allow to login if no password entered.

[@adafam9926]

@@mazeem27n Did you Fixed it?

[@mazeem27n]

I am using different way of security and logging control. Since any one can access to user table if the database stored in not trusted location. Because all VBA and macros are disabled. And ribbon remains visible. Even form modal function doesn’t work and close button remain visible.

[@doggyvlogs418]

Excellent video thank you very much! I had a problem getting it to run but it was only because Access had prevented the new content from working - once this protection was removed it worked perfectly. Thought this may help some of the comments below, cheers and Merry Christmas.

[@tadgh123xx]

+doggy vlogs how do i remove this protection????

[@muskyman705]

Excellent video man. Looked at a bunch of other videos first and just got confused. This worked for me first time. Thanks!

[@estevesazeiteiro]

I had the error 3077. I was able to fix it on my file. I did It like this: rs.FindFirst ("UserName='" & Me.TxtUsername & "'") Hope it may be useful for anyone with that problem.

[@lancevraagom8]

Hi Steve, just want to say thank you for this video series. I am currently working through it and it really is great. Easy to understand and follow. You're a lifesaver.

[@afghantube8709]

Enter correct username and Leave empty password field and enter the button

[@joeroske6363]

Thank you!!!! I had a couple of hiccups but IT WORKS!!!

[@tamaraosbourne8031]

THIS IS THE BEST! I tried so many steps and websites to get this to work and finally you have helped me and it worked! Thank you so so much!

[@tariksuljic5876]

Hi Steve! Thank you for your video! I have a problem that once I enter the username correctly and press enter, the programme does not ask me to input any password but it automatically transfers me to the so-called main form. I would like to access the main form only when both the username and password are correct. I am looking forward to hearing from you! Sincerely, Tarik

[@Hamidali-mx8iv]

Yes, I am having the same issue. If it has been resolved, please let me know.

[@tracy8522]

Its so fun when i type in as you said, and you deleted it when i finish typing hahahaha

[@jbyronwinton2672]

Excellent teaching video. I plan to watch more of your video series to sharpen my MS Access development skills. Thank you.

[@osamabatrikhi5272]

Your information flows like water , I do really enjoy your method and way of providing this knowledge and your way of teaching, Thanks indeed, I appreciate it.

[@snakeeaterahmed6107]

@ Programming: I just can't express how much we can thank you for all your series, really its a lot of helpfull information and tons of appreciations to you sir!

[@dzenk19]

u are fire bro, the satisfaction when everything works is unbelievable

[@clintg3435]

Amazing. Moving from Excel to Access. Very excited, looking forward to learning this. Great instructions. Subscribed, interested in setting up dynamic permissions/views based on each user, and reporting. Thanks for sharing.

[@rabingurung8084]

Thanks you so much... Sir, you have saved me from being failed in my assignment.

[@johanekman3848]

You are a freakin god in explaining what and why!! Five thumbs up!

[@x21tri5]

NO WORDS CAN EXPLAIN YOUR GENEROSITY! Thank you so much steve! :-D Looking forward for more videos from you.

[@DC-mh7bn]

Really helpful. Can't wait to watch the other videos. Many thanks!!! :D

[@JJsANSWER]

This was so helpful, and thank you for sharing the actual database, I am extremely grateful!!! - JJ

[@cnstraight1]

I followed your instructions and found that i didn't even need to put the password in my login form for it to log me in. I do have to have the username however. What did I miss?

[@KKS.22]

Same for me. No password required to login. lol

[@jungjungdelosreyes4147]

Same here, I hope steeve can see this, its almost perfect.

[@douradavidboge6804]

@@jungjungdelosreyes4147 could you post your code. I might help you out

[@douradavidboge6804]

@@KKS.22 Could you post your code, i think i can help

[@KKS.22]

@@douradavidboge6804 i fixed it already. I applied a condition which makes password field a necessary field and hence user cant press login unless there is something in password.

[@lbarbaric11]

Amazing Steve! had an issue but it seems to be resolved below. yay!!!!

[@XaQueHuongVN]

Thanks Steve! I ran the code, and it works great. However, I entered the correct Username, but the password I left it blank and I was able to log in without a password.

[@kevinkwon8126]

Hello. I had the same problem so here is the additional code you need to add: Near the top of the code, (under rs.findfirst part) If isnull(your username field on form) or isnull (your password field on form) then Msgbox “enter valid login or password”, vbokonly + vbinformation, “require data” Exit sub End if

[@denapoleon6006]

This is fantastic! Thank you so much and thanks for being so thorough. I hope I'll learn how to disable the right click mouse button and still get to design view as the administrator in future videos!

[@ProgrammingMadeEZ]

+De Napoleon You do learn this a bit later.

[@AnthonyH1989]

I did this but and getting “complie error method or data member not found” I also don’t have the “immediate” box on the coding screen.

[@jamesanderson5885]

Hate to be the bearer of bad news but I tried this step by step and you can still log in using the correct username and by leaving the password field blank, any idea on how to fix this?

[@jwcolby54]

Two things, the objective of a login is to obscure valid names, not display the names of the users. And NEVER store a password. Store the hash and after the user types in the password, hash it and compare to the stored hash.

[@rakaeagles6735]

I got answer in video link provided in description but what about case-sensitive password.

[@pronounceword]

I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.

[@MahmoudMohamed-tz8mx]

You sir are a helping angle!! Thank you for your effort!! helped me a lot, and I really appreciate it.

[@joeroske6363]

I know this an old video but maybe someone can help. I run Win11 with 3 additional monitors and my laptop. The Password dialog works great whn all of the monitors are connected BUT when I open access with only one monitor the dialog box for the password does not go to the primary monitor, it goes to screen 2 which is not connected. Now do I fix this?

[@afghantube8709]

Hi i creat login form just like you creat but when i enter user name and leave empty password field it works and loged me in successfully Please try correct username and empty passwprd field

[@williamFrSFO16]

Hi Steve! 'Hope you're enjoying your time away. In case you do read this . . . First, I have to say thanks for all your hard work on these videos! One thing I found using Access 2010 on Windows 10 . . . I tried the dbOpenSnapshot, but could not get the thing to work in Access 2010. Access 2010 was getting hung at the outset with an "Undeclared variable." So, I just went back to the old method. Perhaps 2013 was "new and improved?" Everything else worked like a charm. I posted the code there, just in case, but there must be something which must be done in 2010 that is missing. Who knows? Perhaps someone caught it below. I caught the fix, btw, on checking the password. Thanks! I have to research it a bit, but is that in case the field is empty? Anyway, if those using Acces 2010, are having a problem with dbOpenSnapshot, use the old from from Recordset #3. That will work just fine. Thanks again, Steve. ' Declare GLOBAL variables Dim db As Database Dim RS As Recordset Private Sub btnLogin_Click() Set db = CurrentDb ' Set RS = db.OpenRecordset("tbl1Employees", dbOpenShapshot, dbReadOnly) Set RS = db.OpenRecordset("tbl1Employees", dbOpenDynaset, dbReadOnly) RS.FindFirst "UserName = '" & Me.txtUserName & "'" If RS.NoMatch = True Then Me.lblerrUserName.Visible = True Me.txtUserName.SetFocus Exit Sub End If Me.lblerrUserName.Visible = False If RS!Password Nz(Me.txtPassword, "") Then Me.lblerrPassword.Visible = True Me.txtPassword.SetFocus Exit Sub End If Me.lblerrPassword.Visible = False MsgBox " Proceed to Process . . ." ' DoCmd.Close acForm, Me.Name ' DoCmd.Close acForm, "frmLogin" End Sub

[@carolinejccarolinejc707]

Basic Question but now and again, I cant find the words that should be In VBA code "NoMatch and FindFirst are not in the list. can I ask how to add them to the MS Access Database to allow me to use. it is showing error due to these 2 not allowing me to do a basic login form

[@fathiahhusna7191]

Thanksss! It worked!! And I like it how you described and explained each detail. :D

[@davidtither5245]

Just to note, if the password is left blank it still allows people to log in and bypass the password. You also need to add in some code to state if the txtpassword field is null to also return the lblwrongpassword label

[@Chux48]

exactly

[@miraeizhaleito3439]

Thank you sir. Very helpful and lots of information. Also very clear explanation that makes it easy to follow the video

[@caribbeanman3379]

Great videos, Steve! One refinement that can be made to the code of the login screen is to set the red labels to become invisible by coding it in the OnChange event procedure for txtUserName and txtPassword. This would be in the form of a simple If statement that makes the label invisible if it is visible. That way the labels disappear as soon as the user starts correcting the text in those boxes, hinting to the user that the program knows he is changing the values and they will be re-evaluated the next time he clicks on login. As it is in the video, the user will still see his corrected change being labelled as incorrect until he clicks login and by then the screen already closes before the eye can notice the red label disappearing.

[@ProgrammingMadeEZ]

+Caribbean Man Not a bad idea.

[@x21tri5]

+Caribbean Man Wow! Thats great! I have tried it. :-D Thanks man.

[@DogsDaysDiaries]

could you give me the code for the on change event procedure please

[@georgebanin4812]

is there anyway for the login screen to only show,not the window behind

[@ashishsapkalUCIrvine]

Thank you, great video. Tried according to your instructions and ran into this flaw - If the password is empty and the user name is correct - the user can still log in! This means there is no need to enter the password at all. Kindly suggest a fix

[@rturae]

You dah man Steve!

[@medimediagmailaccount2193]

Your training is the best Ive had so far. I do have a question. I did everything on this video but when I hit login it error back to the module " Dim rs As Recordset" I dont know what can be wrong. It matches yours exactly.

[@TechWithSally4D]

i'm trying to make a modern professional LOGIN form, with a lot of new features like inactivity logout, can you please help me in that

[@bakytbeckbeck9085]

Thanks a lot for this great video, very simple and understanding. Keep doing your great supporting Job

[@ProgrammingMadeEZ]

Thank you!

[@AS-lh3bj]

I copy the vba codes but it's weird that sometimes it works fine, sometimes it's unable to enter password, (stuck from 2nd digit). I am using Window 10 and Access 2016

[@iasergeev]

never mind i saw your chat below w/Kevin Willemse where you explain the issue.

[@Chux48]

great video. however if if the password is left blank it still allows people to log in and bypass the password.

[@84guerciotti]

Have this working fairly well but I would like to some code to handle password changes. What I want to do is open another form to prompt the user for new password and confirmation and then UPDATE the table record with the new password. Opening the form is working well but my UPDATE is not working. Have you covered this in any of your other tutorials?

[@hansruss-hofmans4276]

Thanks Steve, big fan of you work. By the way, if I were to leave the TxtPassword field blank, does it pass through the code and open the form?

[@TCKKR]

This was an issue when I followed the tutorial. I just added this block below the second if statement: If IsNull(Me.txtPassword) = True Then Me.lblWrongPassword.Visible = True Me.txtPassword.SetFocus Exit Sub End If Me.lblWrongPassword.Visible = False

[@christopherlubinski9440]

Steve, Everything you did here is amazing Thank you! One issue i found is if a user knows a username and they select log in without entering a password it logs the user in. Did I miss a step somewhere to require a password to be entered?

[@cnstraight1]

Got the same thing

[@tezandd7920]

Same, wasn't sure if I was the only one

[@hatemnabil9233]

He replied to this problem in the comments , and it works Sharna, you'll see in the comments below and in the pop up bubble during the video that there is a modification to the code to fix this problem. Change If rs!Password Me.txtPassword Then to If rs!Password Nz(Me.txtPassword, "") Then And that will fix it.

[@davidllewellyn2739]

Excellent video, very well thought out, very clear and simple progression through all the steps to create a very effective functionality. Nobody could do it better! Many thanks.... David Llewellyn, Paris

[@doborkulabb2643]

You are the best guy out here. My RESPECT brother.

[@advancedquality5336]

Great video; however, I followed all of the step and found that 1) I can log in only the user name and 2) when I re-log in, the login form auto populates the last user name and password. How do I stop this?

[@chal9230]

I am using 2016 Access. When I make the from modal/popup and remove the control, I can no longer close or edit this form.

[@BrunoFerreira-qq5vy]

I accidentaly disabled the input option, now I cant access the form because everyting is blocked and I cant login. How to solve this problem? Thanks

[@christopherjdeford6382]

Steve, thanks for the training and the quick responses. In this video you mention disabling the right click menu that can pop up, but its not addressed in this video. Can you either instruct me how to disable the form right-click menu, or direct me to which video contains the info? Thanks!!!!

[@ProgrammingMadeEZ]

You'll learn more about this in video 59.

[@christopherjdeford6382]

Enjoyed video 59, even tried to use the USysRibbon, even though my Shift+Open didn't override it so I could turn the options on and off. However I never saw where you addressed the "close" option on top of the tabs of forms, unless changing the tab option to window overlay option was implied but never stated.

[@ProgrammingMadeEZ]

You found the solution there to a question I didn't think of when I was making the video. You do need to turn off the tabs.

[@christmaswithcurtis2018]

When I enter my userID correctly and press enter. It logs me in without putting in a password. If I use the mouse and click in each userID and password. Basically want to force user to ONLY be allowed to use mouse. No ENTER/return. Thanks.

[@philipal-annabi6728]

I keep getting this error message does compile error ( User-define type not define) what does that mean

[@elGundzios]

Thanks Steve for your wonderful work! I got a question related to temporary values. I would like to add to your code TempVar from column ID, as a number for tables to indicate who made entries to records. I tried to browse the web before bothering you, but my VBA level is still less than basic. Actually, I don't know how to finish this TempVarLogin = ... could you please give me a hint - what function/command I should use to declare (pull) this value from a table?

[@robb5086]

Hello im geting this error "variable not defined and Private Sub btnLogin_Click() is in Yellow can you help me with this problem .

[@andoovellayan]

Steve, I can open frmMain with correct username and without entering password.

[@FitzDesignz-Jacob]

Password field is not case sensitive. I have changed the password field "Allow Autocorrect" = NO. like the other comments suggested. That didn't solve it. Any ideas how to make the password case sensitive?

[@danielarauzplatas861]

Thanks for your tips, you area good teacher Steve

[@ProgrammingMadeEZ]

Thank you!

[@christophernguyen6082]

Hello Master Bishop; Good effort, It was very nicely explained, you covered almost everything about "Programming in Microsoft Access 2013." You are the best ***** rated! God Bless You and Yours... Thanks for your time,

[@ProgrammingMadeEZ]

Thank you for your kind words.

[@frqwolf]

Ran into a problem with this setup i have Access 2010 the section on the user name works perfect but for the password if i leave the field blank it logs me in

[@ethan3675]

Hey Steve, when I click login, the error "Compile Error: Method or data member not found" appears, highlighting the line "Private Sub btnLogin_Click()" in yellow. How do I fix this? Thanks

[@patsjoel]

same issue and still can't resolve it

[@ahmadalghali90]

egotisticalbastrd you sir are an amazing human being ... god bless your soul

[@udocgi]

Great help, works great, thanks!

[@mechaksawuna262]

Where can I find the concatenation sign on my keyboard?

[@MansoorAhmed00786]

i want that when i open my access document then login form automatically appears and when user add username and password then he can access to the document. Is it Possible? any body help me?????? Thanks Mansoor Ahmed

[@UnnieIU]

yes this is possible. you can go to file-option-current database-display form: (your login form name)-ok make sure you close your microsoft access in order for this to work

[@konvicttedprince]

Great Explanation!! looking forward to more uploads from you.

[@bobstockey1246]

How can I get a printout of the code for this video?

[@maxcrombach1]

Thanks for your video tutorials! They always really help me out! Question: Is there a specific reason why you chose to use a recordset instead of the Dlookup Function? Thanks!

[@khalidtaj5370]

i have found an error after running programe "the expression you entered as query parameter found error : 'pasward'

[@mistyheyden1808]

Hello, this was working for me at one point, now all of a sudden I get variable not defined on dbOpenSnapshot.

[@juliushenderson9942]

Thanks Steve...your solutions was the best of the all I tried, very logical steps and better use of the tools/resources provided by MS Access. My Login is now working perfectly .....julius

[@ProgrammingMadeEZ]

julius henderson Thank you Julius! I'm glad it is working for you.

[@sharnarushby6486]

Hi Steve, thank you for sharing your knowledge!! I have used you code but if the user types their username and leave the password blank it will continue without error, have I done something wrong ??

[@ProgrammingMadeEZ]

Sharna, you'll see in the comments below and in the pop up bubble during the video that there is a modification to the code to fix this problem. Change If rs!Password Me.txtPassword Then to If rs!Password Nz(Me.txtPassword, "") Then And that will fix it.

[@omershaiksar3334]

thanks

[@kasem1977]

@@ProgrammingMadeEZ Thank you sir, I am really worried about it, now its done !!

[@mustafeahmed3130]

Hi programmer thank you for your help i have an issue for instance if I click the right click I can easily close the form and then go through. How I can deactivate the close option in right click manu pls

[@micaelascanlon8761]

Great instructional video thanks so much!

[@ashishtrivedi8253]

Thx for everything but even without putting password if you hit enter button user can get in to database!!! I checked everything but that's the case.. please reply where can I possibly go wrong here.. everything else works fine..

[@fareenacholla1258]

nice video, but my code is not giving the results kindly, steve offer me the sample code for this video am trying to follow along but its not working for me.

[@eladb80]

Hi Steve, i'm using Access 2016 and it doesn't recognize the "Recordset"object - what can i use instead?

[@forktrader7870]

how to add quit feature when user got wrong user/password until count attempt with your login form code? anyway, thanks for the tutorial.

[@badarinarayanach6901]

Hi Steve, thank for your Access videos, I need to create start time and end time Tracker of each transaction, I want to get the end time of previous record and paste in next record as start time along with duration between start time and end time, please help how to create form along with access vba code

[@amitthaupasiri4819]

Thanks for this , much appreciated. However, if you leave both Username and Password textboxes empty, the system allows you to Log in

[@mohamedniusham3572]

If its user id ( number ) how to write the findfirst code??

[@JN-yn3sq]

when I setup the code as stated in the video, all it takes to log in is getting the username correct. i could type in the correct username and hit the Login button and it will bypass the modal window. Ideas??

[@Hubiy2000]

I had the same problem. It appears the problem was because the txt box had a NULL value. Therefore it wasn’t executing the IF statement properly. I fixed this by adding an OR statement to he IF condition to catch null as well. Mine looks like this: If IsNull (rs!Password me.txtPassword) Or rs!Password me.txtPassword Then This catches any null returns. Maybe there is a more elegant solution but this worked well for me. Hope it helps you n

[@harryvaniersel4177]

@@Hubiy2000 Your solution works well; thank you

[@omarmoralesmx]

Hi! si just want to say tha ks for the tutorial I had the code already running, but the thing is that it only runs if I open the form, I want this form to be open whenever I open the program, how do I do that?

[@unitedavenue8441]

Hi Steve, thanks for the tutorial. It was really helpful. However, i noticed that the password isn't case sensitive. For example, if the stored password is P3teR, i am still able to login with p3ter. How can i fix this? Looking forward to your quick response....many thanks

[@kaushikbhattacharya2988]

I have the same issue but it is also for the Username

[@mi6254]

From 15:55 how to click that and what it called again? Thanks

[@teomcam8635]

Great tutorial. Is there any way to encrypt password column?

[@m.o.7661]

great videos, now what is the best way to access the DBMS in my website or over the internet?