How to create Multi User LOGIN FORM in Ms Access With SECURITY LEVEL | Part-2

[@joelolayon72itsfun2learn]

This video tutorial is superb, you made my day!

[@EdcelleJohnGulfan]

Thank you so much for watching this video and your comment is highly appreciated.

[@hansasare4078]

One of my favourite Ms Access Tutorial Channel. John you are the best..

[@jacobt.kolenky1235]

You made my day and success to my mini MS Access Project.

[@EdcelleJohnGulfan]

I'm glad it helps.

[@jeffreyalejaga707]

Quite nice tutorial, easily understand... Really like it. Many thanks Sir...

[@EdcelleJohnGulfan]

Thanks for the appreciation.

[@eng.mohamedfares8659]

Please explain the ATM program required at my university

[@КириллПахомов-х5м]

Спасибо брат ❤🙏

[@EdcelleJohnGulfan]

You're welcome

[@kanyanats.3591]

Many thanks!💗

[@EdcelleJohnGulfan]

You're welcome

[@LIHiker88]

@EdcelleJohnGulfan I have been teaching myself MS Access and your videos are a HUGE help. With this particular part, this works but the problem I am running into is that even when the password is changed, it will now allow the user to login with the changed password as well as "Password" did I miss something?

[@EdcelleJohnGulfan]

Can you paste your code here?

[@LIHiker88]

@@EdcelleJohnGulfan Private Sub LoginBTN_Click() Dim Userlevel As Integer Dim TempPass As String Dim ID As Integer Dim UserVarTemp As String 'TempPass is for Temporaty Password given to the new user If IsNull(Me.Username) Then MsgBox "Please Enter a Valid Username!", vbInformation, "Username REQUIRED!" Me.Username.SetFocus ElseIf IsNull(Me.Password) Then MsgBox "Please Enter a Valid Password!", vbInformation, "Password REQUIRED!" Me.Password.SetFocus Else If (IsNull(DLookup("Username", "Users_TBL", "Username='" & Me.Username.Value & "'"))) Or _ IsNull(DLookup("Password", "Users_TBL", "Password='" & Me.Password.Value & "'")) Then MsgBox "Username or Password is Incorrect!", vbCritical, "Login Denied!" Me.Username = "" Me.Password = "" Me.Username.SetFocus Else Userlevel = DLookup("[SecurityLevel]", "Users_TBL", "Username='" & Me.Username.Value & "'") TempPass = DLookup("[Password]", "Users_TBL", "Username='" & Me.Username.Value & "'") ID = DLookup("UserID", "Users_TBL", "Username='" & Me.Username.Value & "'") UserVarTemp = Me.Username If (TempPass = "Password") Then DoCmd.OpenForm "ChangePassword_FRM", , , "[userid]=" & ID Else If Userlevel < 4 Then DoCmd.OpenForm "HFCAMainmenu_FRM" Forms![HFCAMainMenu_FRM]!CurrentUserTB = UserVarTemp Else MsgBox "Access Denied! Contact Systems Administrator for assistance.", vbInformation, "Not Authorized" End If End If End If End If End Sub

[@darksidemilli]

@@EdcelleJohnGulfan your videos are a huge help for me also. I am also having the same problem, where the user is still able to log in with Password even after the password has been changed.

[@EdcelleJohnGulfan]

Sorry for late reply. I missed one line of code. Try this video. kzbin.info/www/bejne/nH-1i62fjKitg8ksi=KI71_-HdJmXbSfR0

[@AndytheAntsAdventures]

I have been doing coding for years but not in "the game anymore" I understand everything you do.. however!! ..never seen a proper relationship video ..been searching high and low on youube and google! Everyone has very simple videos with one table or one query... please can you do a video on relationships with queries...AND THEN .. do what you did on this video??? Thanks .

[@Jojosmith342]

Thumbs up for Edcelle for the valuable tutorial as always. Is there any way to have different greeting on different day (30 messages /moth) to user "good day" "have a beautiful day" each day they log in? thanks a lot

[@EdcelleJohnGulfan]

Yes using dlookup again.

[@EdcelleJohnGulfan]

Thanks for watching my videos.

[@Jojosmith342]

@@EdcelleJohnGulfan thanks for your quick reply. Is there anyway when user login ENVIRON can make both userID & username show on every form they use? thanks a lot again

[@EdcelleJohnGulfan]

@@Jojosmith342 absolutely Yes. Just use the concatenation method.

[@Jojosmith342]

thank you very much but I just dont know how. Could you please make a video once you have some time@@EdcelleJohnGulfan

[@homekt05]

Best of the best! Many thanks!

[@EdcelleJohnGulfan]

Not so... Thanks for watching.

[@andinascrocroandinas9352]

Hi, if I want show too surname about who do login, how I must to do? thanks so much

[@EdcelleJohnGulfan]

kzbin.info/www/bejne/pnSamaKHmp6hrtU

[@andinascrocroandinas9352]

@@EdcelleJohnGulfan It is very nice, but if value about surname is inside one table, how I can do? because the example take copy from the username that I used for enter, but if I want username and surname in 2 differente box, and surname is not date of input, but is just inside of one table, how I can do? thanks so much. U are very good

[@dolankantibarua5315]

Will you make MS ACCESS full tutorial series video ???

[@EdcelleJohnGulfan]

Nice idea. I will make from scratch.

[@EdcelleJohnGulfan]

Wait for it. Thanks.

[@sbanganaalongan7707]

@@EdcelleJohnGulfan aasahan namin yan sir.

[@mikol1114]

Thank you for this informative video. How about sort male and female data in a tabular form like excel?

[@EdcelleJohnGulfan]

Thanks for watching. For sorting of records, check this link. kzbin.info/www/bejne/qGqVlYh_a9uHpac

[@mikol1114]

@@EdcelleJohnGulfan thanks. sir how about this one, I have data of students, example, grade 1 students, and I want them to enrol in grade 2? any tips sir?

[@EdcelleJohnGulfan]

Use append query.

[@bolinoy818]

Hi. I am currently learning MS Access on my own and so far I am learning a lot from your channel. I just want to ask how were you able to put a picture on upper right side of the screen. Currently, I am also doing it using using "We Browser Control" because I am fetching the image from our internal site. I did manage to place it, however I just could not remove the margins of the control, I could see the picture but the margins were also present. Also, how did you make it rounded and do mouse hover to it. Thank you.

[@justinwilliams3479]

Can I get the full code? I've been trying to do this for days. I have the same issue as someone below where you missed a line of code. I am not sure where that line is supposed to go.

[@EdcelleJohnGulfan]

Check this video. You will find the missing code. kzbin.info/www/bejne/nH-1i62fjKitg8k

[@Abdullah_Alhathloul]

Great

[@EdcelleJohnGulfan]

Thank you so much for watching Abdullah.

[@n2d2cool]

We can use ms access form in Android phone

[@EdcelleJohnGulfan]

There are lots of applications in play store but not recommended. It will not display same as the windows display.

[@devkotadilip5274]

Hlw sir, Maine Costumer table mai ID,Name,PanNo, Address, Phone No, Gmail etc banaya hai, aur dusri table sales ki banae hai Esme ID, Name,PanNo, Address, Particular, Value Rs.,Remarks etc banaya hai. Ab mujhe Sales Form banana hai jisme Name ka combo box ho. Es combo box se name jiska select kare usika PanNo, Address show kare Uske bad sales ki particular, Values, remarks field ko entry karsake aur data sales ki table me save ho. a form kaise bana sakte hai plz help kare.

[@ryanm.8282]

Nice work Sir! but honestly how do this work, because everytime i close the microsoft access then try to open it, i can still open all the tables and forms inside. I cant see the function of this login form. Sorry I'm just learning from scratch and dont have any background in Access but I need this for my activity. Please help, thank you!

[@mloucel7]

make the Login form MODAL

[@1973bouzayani]

Hello Haw i can downloading this ?

[@EdcelleJohnGulfan]

Email me at [e-mail]

[@PuteraAmin33]

@@EdcelleJohnGulfan Hi Eduardo, i like your tutorial. i want to learn from your project. i did sent you my email asking for a copy for this project. if you dont mind can you share this project with me?thank you in advanced

[@bolinoy818]

​@@EdcelleJohnGulfan can i also have a copy of the file. thanks.

[@El-Ge]

Sir, my Access Login still keep the password inside the box, meaning to say, everybody can access my database, for every time I open the database the password is there, no need to type again. How to remove it so that every time open the database, I have to type manually. Thanks for the response.

[@EdcelleJohnGulfan]

Hi. Thanks for the question. Select the Textboxt of your password, open property sheet, select Data and clear the default value. Maybe you set your password as default value.

[@hansasare4078]

Please i have sent you an email for the file and the codes for whole tutorial...thanks

[@gabayodirbaba212]

are you send source to me ?

[@nayyerabbas3957]

As soon as I open the password, the computer shuts down