The Mistery of The Recordset... (1 Viewer)

[GabrielR]

Hi guys, I Need help I cant get this to work!

This is an example of a login screen and a Splash Screen
I need to validate User Name and Password and then pass some values to the program, for Example Name to welcome the user on the splash screen, Type of User to open certain screens buttons etc...

This is based partially in examples found here and some other places, but I can not get a hold of the current Recordset.

PLEASE help

**EDIT**

User Name: Luis Ruiz
Pasword: lion

**End Edit**

Gabriel

 

[GabrielR]

I found the answer!!!

I was trying to open a DAO.Recordset using a Autonumber field.

When I was passing the information to the Recordset I was passing the info of the Autonumber as String, I was getting error 3464.

strSQL = "SELECT * FROM tblUsers WHERE [lngUsrId] =  '" & Me.cboLogin.Value & "'"

I learned that the Autonumber variable has to be passed as it is:

strSQL = "SELECT * FROM tblUsers WHERE [lngUsrId] = " & Me.cboLogin.Value

It works like a charm now!

Thanks.

Gabriel Ruiz

 

[GabrielR]

Just to close this thread see the resolved problem on a sample DB on a thread located HERE

Thanks