Verifying Data against a query or table

[Ryis]

Hello everybody, I am trying to create a form that i can use to verify a
username and password against. when the database opens the form pops up and
the user enters his/hers username and password. i want the form apon submit
to check the username and password against a table and a query then either
open the main window or give an error statement. iw ould also like to keep
the loin window hidden after login in to use as a reference for record
cretion and query filtering. If anybody can help me it would be appreciated.

thanks in advance

Ryan

 

[bhicks11 via AccessMonster.com]

Hi Ryan, Create a small form with an unbound control to collect password. I
use this vba code in a login click button:

Private Sub Command3_Click()
On Error GoTo ErrorPoint

If Me.Text0 <> "yourpassword" Or IsNull(Me.Text0) Then
MsgBox "Incorrect Password!", vbExclamation, "Access Denied"
DoCmd.Close acForm, "frmPassword"
Else

Open your form here

DoCmd.Close acForm, "frmPassword"
End If

ExitPoint:
Exit Sub

ErrorPoint:
MsgBox "The following error has occurred: " _
& vbNewLine & "Error Number: " & Err.Number _
& vbNewLine & "Error Description: " & Err.Description _
, vbExclamation, "Unexpected Error"
Resume ExitPoint


End Sub

 

[bhicks11 via AccessMonster.com]

Forgot to mention, add a control and check the login name.

Bonnie
http://www.dataplus-svc.com

 

[Ryis]

Hi Bonnie,

sorry I am really new at this(access period), i need to check against
numerous user names and passwords in a table or query. and my passwords are
alpha numeric. not even sure where to start with the code. I have done some
simple open form commands but nothing when checking against table info.

Thanks for your help in advance

Ryan