Login form sample

[bseche]

Can someone please send me a sample of their login form. It will ask for user ID and User nameand password and compare it against the table. then i would use the login name to put in the main form. I rather use my own security.
Thank you very much
Bseche@stark-stark.com

 

[Webmaster@worksnotfun.com]

This is how I did mine, I created a popup form and put it in the startup. There are two fields txtUserName & txtPassword and 2 command buttons, cmdOk and cmdcancel

Sub NoEntry()

MsgBox "User name or password is incorrect", vbInformation, "Cannot Open!"
DoCmd.Close

Private Sub cmdCancel_Click()
NoEntry
End Sub

Private Sub cmdOK_Click()
If Me.txtUserName = "Bla" And Me.txtPassword = "Blabla" Then
DoCmd.OpenForm "EnterSomethinginanotherform"
DoCmd.Close acForm, "Security"
Form_Security.Visible = False

Else
NoEntry
End If

End Sub