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: ua-cam.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
@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.
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!
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!
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.
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.
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??
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
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.
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.
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.
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?
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.
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?
@@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.
@ 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!
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
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'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.
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
I'm having some trouble with this where you click the login button but it just sits there. I have to click on one of the fields for the form to perform any function, be it showing incorrect info or navigating to my frmmain form. I doublechecked all the code, including the corrected code at 21:15, and its all the same as yours. Any help or ideas?
when I run it in layout, it just sits there, I assume that's what its meant to do. In form view (I have it set in options to be the first form seen when opened) it does what I mentioned
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?
Hello Steve. Thanks for All the tutorials on this subject. I setup a login box just like you have and notice, through hitting enter to quickly, that if the UserName is correct the login screen will still allow you into the main form, without checking the password. Only if you enter a password does it check it. Can you help to fix this?
Programming no, actually I got the same bug, it doesn't check for password if the username is correct, both "exit sub" statements are inside both if. I'll be checking again but I'm a beginner to VBA so I may not see where the issue is. I would appreciate if you get this right for us because your videos were extremely helpful and so well explained..
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
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.
+luka jukic It's some code that I accidentally had on my main menu form that was causing an error. It was not relevant to what we were doing in the video, it's just that when the main menu was trying to open some of the code I had on it was not fully created yet causing an error. Again, completely irrelevant code for what we were doing.
+Programming Thanks for the asnwer, but it seemed I had the same exact problem with code written before, managed to fix it 3 minutes after I posted the question, it's working fine ^^ Thank you again!
When I attempted to use this code, the error messages do not appear but rather #Name? appears in red in the label boxes. any idea what I am doing wrong?
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
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!!!!
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.
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
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.
How do I add a third field to the login form that has to be matching with the other 2 like a (company name )that exist on the table as an integer because it's a lookup from another table Thank you
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!
Hello, I hope you can read this... Got a problem here. My bosses here plan to have simultaneous inputting of data in this database, so most probably, I need to come up with a server..where we can update the data simultaneously.. through log ins maybe or whatever.. have you given a segment about it?
+Anne Angus Caylan I suggest you split the database, which you will learn about later in this series. And I also suggest moving your data to a SQL server, which you can learn about in the Advanced series.
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
Hi, I followed your instructions by letter. But I do not have to type in the Password for the Main Form open up and the login form closes. What did I do wrong?
Hi. You didn't do anything wrong..😋 you need to find this line (line #11 I guess) and complete this code and that will solve it ..If rs!Password Me.TxtPassword or is null (Me.TxtPassword) Then
can set the user name like combo box? just to choose from list and just key in only password, that will save time for user and less typo error possibility.
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?
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.
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.
Hi Steve, You mentioned a global variable that can be used across all forms; is there a way to use similar variable between apps - I need to pass a variable holding a selected folder (string) from Access to Visio... Thanks.
Abe Ibrahim not in the way you are thinking, no. However you can open documents, emails, etc from within Access and put values into those documents. See my video on send emails in outlook in my advanced series, or Exporting data to Word in my how to video on it.
if we left password textbox empty and hit enter then it goes to log in. and also if we enter user name and hit enter it also log in. plz clear all these for me.
i followed you exactly to create the form and the code, but i get this error in yellow color in vb when i run the login form, rs.FindFirst "UserName='" & Me.txtUserName & "'" and the login form is taking only username, it is not checking the password. Kindly advise.
It would help if we knew what the error was. Also, please look at the work files. There is a bug fix which is mentioned in the video, the description, and in the comments.
I believe it means, you probably have that field in the table with a different name comparing with the one in the code. It may happen if you use "-" in a word, for instance. In that case, the code will ad spaces before and after the "-".
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?
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!
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.
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
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
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?
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
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.
Compile Error Method or Data Form not Found it is showing this box when i click on Log in and it highlights The >>>part rs.FindFirst "UserName='" & Me.txtUserName & "'" >>> .txtUserName
Hi Steve, one more question:how we can get the Logged-In username or in other words the name of the user who logged-In, in our Main-Form or in the reports maybe somewhere in the header or in a column so that we know who modified or entered the data. or the data have been entered or modified by who.Thank you very much for your support.
I typically save the UserId in the TempVars collection, then I can just do a dlookup for the username. But you could store the username in the TempVars collection as well. It's up to you.
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?
Steve, in coping your code, the only problem I have is when you put in the correct and leave the password null, it still took you the main menu any way. Any quick fixes? I tried a few thing but, they didn't work.
+Louis Bailey Jr This has been covered fairly extensively in the comments, and fixed in the work files. There is also an annotation in the video regarding the solution which is to wrap an NZ function around the password textbox.
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 programming. I'm able to open the login window by clicking the 'Form View' after i key in all those coding. But when i try to double click the login form from the navigation pane, the login form become invisible, but I'm still able to type the username and password to login. Can you help me identify the problem please. Thank you.
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: ua-cam.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!
Excellent video man. Looked at a bunch of other videos first and just got confused. This worked for me first time. Thanks!
Hi there, I'm a novice but followed your tutorial and worked first time.... a huge thank you... :)
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.
u are fire bro, the satisfaction when everything works is unbelievable
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.
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??
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
@@Hubiy2000 Your solution works well; thank you
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
Excellent teaching video. I plan to watch more of your video series to sharpen my MS Access development skills. Thank you.
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.
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!
From 15:55 how to click that and what it called again? Thanks
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.
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?
How do you fix the "right click" option at 5:53? Pleaseeee
How do you eliminate those
(Edited)
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????
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
Really helpful. Can't wait to watch the other videos. Many thanks!!! :D
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 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.
@ 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!
This was so helpful, and thank you for sharing the actual database, I am extremely grateful!!! - JJ
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.
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
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'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.
NO WORDS CAN EXPLAIN YOUR GENEROSITY! Thank you so much steve! :-D Looking forward for more videos from you.
Thanks you so much... Sir, you have saved me from being failed in my assignment.
You are a freakin god in explaining what and why!! Five thumbs up!
is there anyway for the login screen to only show,not the window behind
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
I'm having some trouble with this where you click the login button but it just sits there. I have to click on one of the fields for the form to perform any function, be it showing incorrect info or navigating to my frmmain form. I doublechecked all the code, including the corrected code at 21:15, and its all the same as yours. Any help or ideas?
+sphinxny Try doing a compact and repair.
still doing same thing. The button outlines with a dashed line but doesn't continue to the form unless I click one of the text boxes
Are you running it in layout view or form view?
when I run it in layout, it just sits there, I assume that's what its meant to do. In form view (I have it set in options to be the first form seen when opened) it does what I mentioned
Hmm.. I'm really not sure then
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.
I got answer in video link provided in description but what about case-sensitive password.
Thank you!!!! I had a couple of hiccups but IT WORKS!!!
I keep getting this error message
does compile error ( User-define type not define)
what does that mean
Amazing Steve! had an issue but it seems to be resolved below. yay!!!!
Hello im geting this error "variable not defined and Private Sub btnLogin_Click() is in Yellow can you help me with this problem .
Hello Steve. Thanks for All the tutorials on this subject. I setup a login box just like you have and notice, through hitting enter to quickly, that if the UserName is correct the login screen will still allow you into the main form, without checking the password. Only if you enter a password does it check it. Can you help to fix this?
Make sure you have the "Exit Sub" statement inside the scopes of both IF statements. It sounds like you're missing it at the password check.
Programming
no, actually I got the same bug, it doesn't check for password if the username is correct, both "exit sub" statements are inside both if. I'll be checking again but I'm a beginner to VBA so I may not see where the issue is. I would appreciate if you get this right for us because your videos were extremely helpful and so well explained..
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.
Where can I find the concatenation sign on my keyboard?
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.
what happened at 26:30? i dont understand what you did to fix it...
+luka jukic It's some code that I accidentally had on my main menu form that was causing an error. It was not relevant to what we were doing in the video, it's just that when the main menu was trying to open some of the code I had on it was not fully created yet causing an error. Again, completely irrelevant code for what we were doing.
+Programming Thanks for the asnwer, but it seemed I had the same exact problem with code written before, managed to fix it 3 minutes after I posted the question, it's working fine ^^ Thank you again!
When I attempted to use this code, the error messages do not appear but rather #Name? appears in red in the label boxes. any idea what I am doing wrong?
Have you compared your code to the work file?
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
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!!!!
You'll learn more about this in video 59.
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.
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.
Hi Steve, i'm using Access 2016 and it doesn't recognize the "Recordset"object - what can i use instead?
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
Same issue, please help. Other than that great video
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.
How do I add a third field to the login form that has to be matching with the other 2 like a (company name )that exist on the table as an integer because it's a lookup from another table
Thank you
I demonstrate this later on in the series.
Ok thank you
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!
Adam thank you very much for the help!
Thanksss! It worked!! And I like it how you described and explained each detail. :D
i have found an error after running programe "the expression you entered as query parameter found error : 'pasward'
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.
Hello, I hope you can read this... Got a problem here. My bosses here plan to have simultaneous inputting of data in this database, so most probably, I need to come up with a server..where we can update the data simultaneously.. through log ins maybe or whatever.. have you given a segment about it?
+Anne Angus Caylan I suggest you split the database, which you will learn about later in this series. And I also suggest moving your data to a SQL server, which you can learn about in the Advanced series.
Thank you! :)
hello how can i get rid of the right click option were i can acess thedesign view because the login works thanksss.
I cover that in a later video.
How can i make the username and password case sensitive?
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
Hi, I followed your instructions by letter. But I do not have to type in the Password for the Main Form open up and the login form closes. What did I do wrong?
Hi. You didn't do anything wrong..😋 you need to find this line (line #11 I guess) and complete this code and that will solve it ..If rs!Password Me.TxtPassword or is null (Me.TxtPassword) Then
@@ashishtrivedi8253 Thank You. I will look into it
can set the user name like combo box? just to choose from list and just key in only password, that will save time for user and less typo error possibility.
+Lakshmiganthan Thotlan watch episode 35.
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?
You are the best guy out here. My RESPECT brother.
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.
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 !!
How can you enforce the password complexity in this login form?
Hi, for some reason if i supply a empty string with a correct username, it still logs in successfully.. is there a fix for this?
+Christian Cole Yes, the answer is in a few different places. The description, the comments, and an annotation during the video.
Steve, I can open frmMain with correct username and without entering password.
Help please! Error at dbopensnapshot (Variable not defined).
+Atul Srivastava I'm afraid there is no way to diagnose the issue with this limited amount of information.
great videos, now what is the best way to access the DBMS in my website or over the internet?
Hi Steve,
You mentioned a global variable that can be used across all forms; is there a way to use similar variable between apps - I need to pass a variable holding a selected folder (string) from Access to Visio... Thanks.
Abe Ibrahim not in the way you are thinking, no. However you can open documents, emails, etc from within Access and put values into those documents. See my video on send emails in outlook in my advanced series, or Exporting data to Word in my how to video on it.
if we left password textbox empty and hit enter then it goes to log in. and also if we enter user name and hit enter it also log in. plz clear all these for me.
Please read any of the annotations made, or the video description, or any of the 40+ answers to this in the comments. Thank you.
I cant compile. Private sub login_click() is highlighed in yellow and in the findfirst row. Me.txtusername is highlighted in blue. Pls help!
i followed you exactly to create the form and the code, but i get this error in yellow color in vb when i run the login form,
rs.FindFirst "UserName='" & Me.txtUserName & "'"
and the login form is taking only username, it is not checking the password.
Kindly advise.
It would help if we knew what the error was. Also, please look at the work files. There is a bug fix which is mentioned in the video, the description, and in the comments.
hi...i dont have that immediate box at the bottom how or where can i get it....
From the VBA code window: View -> Immediate Window
thank you so much
run-time error '3070':
The Microsoft ACCESS DATABASE ENGUNE DOES NOT recognize 'LoginID' as a valid field name or expression.
what does that mean
I have no idea and we would need some sort of context as to when or how you get this error.
I believe it means, you probably have that field in the table with a different name comparing with the one in the code. It may happen if you use "-" in a word, for instance. In that case, the code will ad spaces before and after the "-".
Hi, may I ask why need to create form: frmMain ??
Thank you sir. Very helpful and lots of information. Also very clear explanation that makes it easy to follow the video
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?
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.
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.
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
Hello Sir Good Evening, How to create signup form and Create Remember me option in form
Hello! For my Login Button, I don't have the Code Builder under the Events Property Sheet! Anyone can help?
That's very strange. Are you running a database in Access Run-Time edition, or the full version?
Shouldn't we close the recordsets when we leave the sub?
You sir are a helping angle!! Thank you for your effort!! helped me a lot, and I really appreciate it.
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
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?
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
If its user id ( number ) how to write the findfirst code??
You dah man Steve!
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.
Compile Error Method or Data Form not Found
it is showing this box when i click on Log in and it highlights The >>>part
rs.FindFirst "UserName='" & Me.txtUserName & "'" >>> .txtUserName
+Caroline Jc Make sure that this code is in the module behind the login form and that you have a textbox named txtusername on your form.
Hi Steve, one more question:how we can get the Logged-In username or in other words the name of the user who logged-In, in our Main-Form or in the reports maybe somewhere in the header or in a column so that we know who modified or entered the data. or the data have been entered or modified by who.Thank you very much for your support.
I typically save the UserId in the TempVars collection, then I can just do a dlookup for the username. But you could store the username in the TempVars collection as well. It's up to you.
Ok thanks. and could you show us how to do it?Thanks.
Naseem Waziri I've already done a video on it. It's in the How To section.
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?
How can i integrate this into a website? Or can i.
Steve, in coping your code, the only problem I have is when you put in the correct and leave the password null, it still took you the main menu any way. Any quick fixes? I tried a few thing but, they didn't work.
+Louis Bailey Jr This has been covered fairly extensively in the comments, and fixed in the work files. There is also an annotation in the video regarding the solution which is to wrap an NZ function around the password textbox.
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 programming. I'm able to open the login window by clicking the 'Form View' after i key in all those coding. But when i try to double click the login form from the navigation pane, the login form become invisible, but I'm still able to type the username and password to login. Can you help me identify the problem please. Thank you.
+Lee Kah Ming There are far too many reasons this could be happening. Why not try using the work file code instead.
Hi, thx for reply. I already found out the solution by setting the auto center to yes.
Hi I need your help
how I protect my database access from copy
+Ahmed cad I recommend watching the whole series. I cover securing the database and preventing code stealing later.
+Programming okay please lit me know if you get it
thank you
Get what? Securing your database is covered later in this series. Keep watching and you'll learn what you need to do.
I show a video make this i can send you but he talk Arabic