2.26 Password Login Form / screen using VBA in Access

Creating a Login Form and password protecting your database

Here's the code I used:

Username.SetFocus
If Username = "user1" And Password = "user1" Then
MsgBox "Access Granted", vbInformation, "CD Shop"
MsgBox "Welcome", vbInformation, "CD Shop"
DoCmd.Close
DoCmd.OpenForm "F_Switchboard"
Else
MsgBox "Please re-enter your Username and Password."
End If

Category:

Howto & Style

Tags:

• Microsoft
• Access
• VBA
• Username
• Password
• Button
• Protect
• Code
• VB
• Login
• If
• Else
• ElseIf
• MsgBox
• SetFocus
• End
• Private
• Sub
• OnClick
• On
• Click

[ConswaylahBear]

Ive done exactly wat is said but when i press the button nothing happens... plz help asap

[Firchild]

@ConswaylahBear Read the feedback to the previous, identical comment..

[hlmasoud]

i did it as told but nothing happened when i press on the button.

please help

[Firchild]

@hlmasoud Check your code is referencing the text boxes username and password (and that you've named the text boxes from text1, text2 etc - and not changed the label instead)

[hlmasoud]

@hlmasoud

found the error. i had the security warning disabled.

1000 thanks for this vedio.

cheers

[Firchild]

@hlmasoud No worries, that security warning is a pain! It does stop nasties though..

[BrunoMarsCrazyy]

OMG thanks needed it for my computing coursework

[baysharks21]

I'm sorry - I finally figured it out..

THANKS!!!

[mrosamabinobama]

YOU ARE AWESOME!!!!!, SAVED MY LIFE!!!!! (I had to do assignment)

[wellhrd]

It works well i follow using 2007! Gr8 man!

[hi2udemon]

@Peeboontheng two words 4 me.....thumbs up! :)

[Peeboontheng]

1 word 'COOL'