Search results

Thanks again, maybe the public variable would word. This it what I have at the back of the login button: Private Sub cmdLogin_Click() Dim myDB As DAO.Database Dim myQDEF As DAO.QueryDef Dim myRST As DAO.Recordset Dim strSQL As String blnPasswordOK = False...

Thanks for the code but I do not want to the login form to remain opened when I click the login in button. Isn't there a code(sql) that calls the user that logon from the user table? Someone spoke about Environment() but I am stuggling with coding it. Any idea? Thanks

Yes I am using a Logon form with the user name and password in a table called tblUser. What I would like to do is when the Logon form closes, I want to place a field on the welcome form that will show the username of the user from the table that has logon. Thanks

Hi, I have an Assess 2007 database with a user table. This table holds database user names and user passwords an entry permission to the database. I also have a welcome form that activates when user enters the database using either of the user names and user password in the user table. Now, I...