How to Create Login Form in Microsoft Access | Multi User|

[@MalikZahoorkhan-w7o]

nice sir g

[@bobby_ben]

If I input same Username with a random password,it works still. How do I fix the same username not to use a random password?

[@DynamicProgrammer1]

No bro random password is not working cheek your vba code

[@PritamSingh9119]

Use "Or" instead of "And". Still this code has some flows like even if one you provide one password from the table it will still work.

[@jossurbab]

Any username with right password opens main form🤔🤔🤔

[@DynamicProgrammer1]

Please check your code

[@jossurbab]

@@DynamicProgrammer1 Ok.

[@silentqueen4838]

User name missing operater error showen by login form

[@Peregas]

Why i cant use two words for example "admin username"
Reference 14:20

[@Peregas]

It became error or something

[@nurfatinhalwaizzatimohdari2433]

blur view for command

[@acrobaticboy7604]

Run-Time error 2471 The expression you entered as a query parameter produced this error :"Password"

[@DynamicProgrammer1]

Check your query

[@mathematicsandphysics4233]

How to use this left heavy comma ❛

[@mathematicsandphysics4233]

1 More thing what is placed after 2nd time username and password in login form. Is it inverted commas?

[@farooqkahn2847]

Sound is off in video

[@farooqkahn2847]

Sir please start access

[@DynamicProgrammer1]

OK In shallah

[@acrobaticboy7604]

Where is mistake can you tell me ? Private Sub Command7_Click()
If (IsNull(DLookup("UserName", "lbl_Login", "Username ='" & Me.txtuser & "'"))) And _
(IsNull(DLookup("Passsword", "lbl_Login", "Passsword ='" & Me.txtpassword.Value & "'"))) Then
MsgBox "Username or Password is incorrect", vbCritical, "Check You Credentials"
Else
MsgBox "Welcom to Database"
DoCmd.OpenForm "MainForm", acNormal
DoCmd.Close acForm, "Login", acSaveYes
End If