Conditional Macros for Login Form

[Access_Help]

Hello All.

I am an absolute beginner to Macros so please consider this when replying

I need to create a macro which simply checks whether the username and password entered on the form matches the one in a table in the database. If it matches then it takes you to a specified form otherwise returns a message saying 'incorrect username name and password'.

I require this urgently, replies appreciated!

Thanks

 

[namliam]

No can do in a macro I think... You need "actual" coding...

See if you can find a sample in these threads
http://www.access-programmers.co.uk/forums/search.php?searchid=2027146

Or try searching the reference forums
http://www.access-programmers.co.uk/forums/forumdisplay.php?f=26

If you have specific questions on one of the subjects we/I would be happy to answer them.

 

[Access_Help]

^ Thanks. I was actually trying to use conditional formatting to avoid coding.I have found another way round it .

 

[JBurlison]

Here is an example of my login screen behing my login button

    Static LogonAttempts As Integer
    Dim SaiCurrentUser As String

    SaiCurrentUser = ""
    If Me.Password.Value = DLookup("[Password]", "[User Name]", "[User Name] = '" & Me.User_name & "'") Then
        SaiCurrentUser = [User Name]

        DoCmd.Close acForm, "Login Screen", acSaveNo
        DoCmd.OpenForm "Switchboard"
 
    Else
        LogonAttempts = LogonAttempts + 1
        MsgBox "Password Invalid. Please Try Again", vbOKOnly, _
               "Invalid Entry!"
        Me.Password.SetFocus
        Me.Password.Value = ""
 
 
    End If
    If LogonAttempts > 3 Then
        MsgBox "You do not have permission to access this database.Please contact your database administrator."
        Application.Quit
    End If