Need help with VB Logon Screen

[tmb842]

Hey Guys,

I am having issues with this stupid logon screen.

I am trying to logon with trent.bourne and the password as fish

The system cant find the stupid file and I cant get the logon form to work.

Can someone have a lookie at file and let me know where I have stuffed up...

Cheers

Trent

VMPD_ASSIST_FILE.zip

[Gina Maylone]

This line of your code (If Me.txtPassword = DLookup("Password", "vmpduserdetails", "Me ]=" & Me.cboEmployee.Value) Then
remove the bracket after "Me

[tmb842]

I just updated it to



If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then
MsgBox "You must enter a Password.", vbOKOnly, "Required Data"
Me.txtPassword.SetFocus
Exit Sub
End If

If Me.txtPassword = DLookup("Password", "vmpduserdetails", "ID =" & Me.cboEmployee.Value) Then
ID = Me.cboEmployee.Value

However it still gives me the error

[Gina Maylone]

This table "vmpduserdetails" doesn't exist. Try this: =DLookUp("[Password]","[VMPD_System_Logon_Details]","[VMPD_System_Logon_Details]![ID]=[ID]")

[Gina Maylone]

Also - I think your password may be mis-spelled. Re-enter fish in the user screen.

[tmb842]

Hi Gina,

I think I love you!

Thanks so much for your help!

Cheers

Trent

[Gina Maylone]

You're welcome Trent! Glad it worked out!