56. Creating A Classic Login Form (Programming In Microsoft Access 2013) 🎓
Vložit
- čas přidán 27. 07. 2024
- We are aware of the "No Password Needed" bug. A newer version of creating a classic login form can be found at
• Let's Build A Login Sc... or look in the work files for the solution.
Error at 21:15 - Please look at the work file: github.com/Xipooo/Programming...
Creating A Classic Login Form in "Programming in Microsoft Access 2013". Hosted by Steve Bishop.
In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).
Click here for the full playlist of "Programming in Access 2013"
• Programming in Microso...
Click here for the Work Files of this series:
github.com/Xipooo/Programming...
----------
Become a member today for only $5 a month!
/ @programmingmadeez
When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
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: / @coffeewithsteve
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: czcams.com/channels/eXAUvo5xxDY_b-lSknPC1A.html
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
@Marcos Rene instablaster =)
@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.
@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
@Marcos Rene Happy to help xD
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!
Really helpful. Can't wait to watch the other videos. Many thanks!!! :D
This was so helpful, and thank you for sharing the actual database, I am extremely grateful!!! - JJ
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!
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.
Enter correct username and Leave empty password field and enter the button
NO WORDS CAN EXPLAIN YOUR GENEROSITY! Thank you so much steve! :-D Looking forward for more videos from you.
@ 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!
You dah man Steve!
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!
This guy make my Job Easier Thanks bro.. Just follow the Steps Carefully 110% it will Work
It's working with wrong password but allow to login if no password entered.
@@mazeem27n Did you Fixed it?
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.
Excellent video man. Looked at a bunch of other videos first and just got confused. This worked for me first time. Thanks!
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.
michie i0113 I am so glad you are enjoying the series.
Great Explanation!!
looking forward to more uploads from you.
Amazing Steve! had an issue but it seems to be resolved below. yay!!!!
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.
+doggy vlogs how do i remove this protection????
u are fire bro, the satisfaction when everything works is unbelievable
Thanksss! It worked!! And I like it how you described and explained each detail. :D
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.
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.
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
julius henderson Thank you Julius! I'm glad it is working for you.
Thanks a lot for this great video, very simple and understanding. Keep doing your great supporting Job
Thank you!
Excellent teaching video. I plan to watch more of your video series to sharpen my MS Access development skills. Thank you.
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
Hi there, I'm a novice but followed your tutorial and worked first time.... a huge thank you... :)
Thanks you so much... Sir, you have saved me from being failed in my assignment.
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.
I love you Steve :)
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.
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!
I like this video. Thanks Sir, You help me to finish my homework :))))
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!
+De Napoleon You do learn this a bit later.
Thanks for your tips, you area good teacher Steve
Thank you!
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?
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.
+Caribbean Man Not a bad idea.
+Caribbean Man
Wow! Thats great! I have tried it. :-D Thanks man.
could you give me the code for the on change event procedure please
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
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.
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.
@Tyrielle Cole, check with the work file linked in the description of the video.
Programming I just copied your code and replaced with my form name etc...it still brings me to user defined error here:
"Private Sub btnLogin_Click()
Dim rs As Recordset"
Try using DAO.Recordset then instead of just recordset.
hey it still not working on mine please any other suggestion please
Im using Access 2016
Make sure you have the correct references set. Make sure to check the MS Office 15.0 Access DB Engine Object Library. Had the same issue.
Thank you!!!! I had a couple of hiccups but IT WORKS!!!
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,
Thank you for your kind words.
Its so fun when i type in as you said, and you deleted it when i finish typing hahahaha
thank u very much!!! it work out
You are a freakin god in explaining what and why!! Five thumbs up!
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
same issue and still can't resolve it
egotisticalbastrd you sir are an amazing human being ... god bless your soul
Братан, спасибо тебе от души!
Thank you very much. This helps me a lot. God bless
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.
Thank you Mr Aitch! Thanks for watching.
hi steve, on the aforementioned code for the login form is there a way to make it case sensitive
Thank you so much, you motivate me for using Access :)
never mind i saw your chat below w/Kevin Willemse where you explain the issue.
You are the best guy out here. My RESPECT brother.
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
Yes, I am having the same issue. If it has been resolved, please let me know.
Thank you sir. Very helpful and lots of information. Also very clear explanation that makes it easy to follow the video
Hey Steve, I've made it this far. I was hoping in the VBA section we would be covering some "Import, Append, and Delete Duplicate Records" code (As in all in one shot). I came here based on the import file tut you had created and got hooked on these tuts. Is it not possible? Is it a combination of things (Macros, SQL, and VBA)? I am sorry I am very new to this and have followed your videos thus far and have been able to accomplish all the tuts. Are you able to point me in the right direction or is this further in the videos? Thanks
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
ooo all your videos are aweosome, i like them all
Thank you.
Hi Steve. Thanks for the great series. However, the link in the description returns the following error: "Sorry, the file you have requested does not exist." Any solution?
great videos, now what is the best way to access the DBMS in my website or over the internet?
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?
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.
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
You sir are a helping angle!! Thank you for your effort!! helped me a lot, and I really appreciate it.
Great help, works great, thanks!
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
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
Thank You, helped me a lot
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
Hi Steve, i'm using Access 2016 and it doesn't recognize the "Recordset"object - what can i use instead?
can we also set our "rs" when the form loads instead of when the login button gets pushed ?
Yes. You can set the rs during form load. I recommend doing it on click though simply because you want your data retrieval as close to the event trigger as possible. Your data could get stale and user might have been disabled, the password might have changed, or something else between when the user opened the form and when they logged in.
Great, completely understood!
Great instructional video thanks so much!
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
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
Thanks, this just saved my arse for a school project!
Glad to hear it.
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.
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 ??
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.
thanks
@@ProgrammingMadeEZ Thank you sir, I am really worried about it, now its done !!
Hello Steve good tutorial. Could you help me with this challenge. How to make a journal entry form in which total debit must be egual to total debit and each time you enter a specific amount in one side the difference appears with a combo box in which you'll choose a new account line that will equilibrate the 2 columns.
Your Journal table should have a Debit column, a Credit column, and an Account Number column. Each transaction should have the Debit and Credit columns equal 0. So if you have a credit of $20.00, then you need a debit of -$20.00. Of course the Account column will be filled with the account that the transaction will be recorded for. This is a very common Journal table setup.
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.
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?
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
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?
Got the same thing
Same, wasn't sure if I was the only one
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.
Thankyou Steve!
i luv u.
Hi! Your videos are great! I have a question though, is it possible to create a main menu specifically for each users? Like user can only view or have an access to an specific data and such data when they update i - it will automatically update as well the masterfile?
+Gian Samar I suggest you watch my How To Manage User Access video.
I got answer in video link provided in description but what about case-sensitive password.
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?
Hello Sir Good Evening, How to create signup form and Create Remember me option in form
Hi Steve,
I followed through with the steps, but i noticed that I was able to login putting in the username only. I just typed the username, ignored the password field and then click the login button and I was able to login.
Please explain how I may resolve this issue.
Thanks in advance for your help! A link to
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
I have the same issue but it is also for the Username
omg this is just awsome stuff... Thank you so much.
Hello, this was working for me at one point, now all of a sudden I get variable not defined on dbOpenSnapshot.
Thank you soo much! It worked!!!
Thank you, it's great!
Doesn't this leave your Log in form completely open to an SQL injection.
I'm not referring to the possibility that someone will be able to "hack" the form, more likely when the user enters there username wrong and gets an error message you're not catching.
Would it be better to use a parameterized query or is there a more efficient way to traverse the recordset?
Hi Steve...You really doing great job. I have tried it bit the code error on If Nomatch and logs in if I even don't enter user name or password. Plz guide. Regards
how to add quit feature when user got wrong user/password until count attempt with your login form code? anyway, thanks for the tutorial.
thanks for this tutorial Steve, i find it to be very helpful. I created a login form following this video and it worked well, (picks up correct/incorrect passwords & login id, opens the next form upon identification etc.), but i also noticed that i can still get through without filling the password (i.e. just entering the user id info and then hitting "enter"), would that happen if you try it in your version in this video or is there something in my code i am missing?
How do you fix the "right click" option at 5:53? Pleaseeee
How do you eliminate those
(Edited)
i have a front end and a back end. the tables in the front end are linked to the back end. so i guess what i could is when a user opens the application, i could hide the stuff on the left side and just have them maneuver through forms and reports, right?
Yes. Ideally they should never see the navigation pane, and I disable the menu/ribbons. I show you how to do that in episode 59.
Thanks for Great Tutorials, and this user login form which works great. However, I have one issue I hope you can help me with.
Distributing this Database file to someone else and they put the Database file on their desktop for example, it creates a security warning for the user opening the database for the 1st time, and with the Login Form set to Modal, the user can't click the Accept Security Warning - is there a way to disable the security warning for a user automatically, or for the current database?
Hey Steve, one question. I followed your instructions and compared my VBA with your google work files.. The login works but sometimes, i get an error saying "OpenForm action was cancelled" which prompts me with the debug window. And the "DoCmd.OpenForm "frmMain"" is highlight yellow. This error is seemingly random as it works fine some moments but doesn't in others. Do you know anything about this and how to resolve it? Thank you.
Make sure you do a compile followed by a compact/restore. Sometimes it can just be buggy. Additionally you might be encountering the "phantom breakpoint" issue. If you had previously set a breakpoint in your code and compiled while that breakpoint was set, you can sometimes end up with a breakpoint in the compiled code. The only way to fix this is to make sure you clear all breakpoints that you've set, change something in your code (usually just add a space on a line somewhere), then recompile and that should get rid of the phantom breakpoint.
Vector Vent for anyone else who has this issue, swapping the open form and close form order fixes this. I had the same issue.I think it's down to trying to open a poo up form whilst there is a modal form already open not allowing anything being accessed over the modal form. Closing the login form first allows the new form to open in it's place.
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?
Same for me. No password required to login. lol
Same here, I hope steeve can see this, its almost perfect.
@@jungjungdelosreyes4147 could you post your code. I might help you out
@@KKS.22 Could you post your code, i think i can help
@@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.
I have followed your instructions to the letter, and included the corrections on the 'work file' and 'Eduardo Esteves' ' fix concerning brackets. But I am receiving a run time error '2501' and when Debug is pressed it highlights the:
Docmd.OpenForm "frmMain"
line showing that there is something wrong with the code on this line. Can you please advise? I can show you further info if you wish.
First, make sure there is a form called frmMain. Second, make sure that the form can open even if it's not called from the login. And if that is all correct, then do a compact and repair on your database. You may have something corrupt.