This means I capture the userID thru TempVar and the user can also use an Alias to login as well. i.e. nickname.
txtuserID = UserName logging into database
txtpswd = UserName password that matches txtuserID
This is on frmLogin
The user can login using their userID or Alias and of course matching password.
tblUserSecurity_Sec is the table where everything is stored.
I want to be able to use TempVar so I can use it elsewhere in the db.
Code: Select all
Dim TempUserLogin As TempVar
Dim TempAlias As TempVar
TempVars!TempUserLogin = Me.txtuserID.Value
TempVars!TempAlias = DLookup("Alias", "tblUserSecurity_Sec", "Alias = '" & userID= '" & txtUserID "'"))
‘Can I do this?
If TempVars!TempUserLogin = Me.txtuserID.Value & TempVars!TempAlias & "" And
If Not IsNull Encrypt(DLookup("pswd", "tblUserSecurity_Sec", "pswd='" & Me.txtpswd & "'")) Then
‘Login