Duane.
There two text boxes that are named
ID
PW
What is entered into the text box are numbers that when entered does the lookup per the ID_PW_Check to see if it is a valid employee and Password as well as their User Type (Admin/Uder). If they are a valid employee and depending on their...
If you mean on the log in form, the control source is in the ID_PW_Check Query which has the following fields
ID which is their Employee ID.
PW
User Type Code
User Type
If you mean the daily hours, currently because of all the trial and errors there is not a control source. The form was...
Form name is Login.
Here is the code for the Login
Private Sub Login_Click()
On Error GoTo Err_Login_Click
Dim varEvent As Variant
Dim stDocName As String
varEvent = DLookup("[UserType]", "[ID_PW_Check]")
If Not IsNull(varEvent) Then
stDocName = "Switchboard" &...
Ok good to know on the attachments. Thanks.
I just want the value to appear. For now the only form using this information is the Daily hours. Of course that is subject to change later down the road.
I am not sure if this matters or not, however there several tables and queries that has...
Ok. I am attaching the form and the some other visuals for you to see.
Here is the process I would like it to do.
Logon (Login Screen attachement)
Populate the name and Employee ID fields (daily Hours Screen) without asking for parameters
Also included is the code for the Daily hours and...
Good Morning Duane,
The Log in form is used to sign into the system. I have it where it closes after they get done logging in.
I am sorry. My misunderstanding (which is not REAL hard on this project for me) what you were asking for or suggesting in the orginal thread. This project has...
Thank you Duane,
Yes the log in form is used so sign into the db. However when I set the visable property to false it does not show the form at all.
I am sure I am missing something in the above explaination.
Still needing a solution to this issue.
Scenario,
Have a form that the employees enter their daily hours in (production based company), I would like to have two fields to auto populate when the employee logs into the db. The two fields are their name and employee ID.
Currently my db has...
Duane,
thank you for responding. the values for the ID and username are stored on a table when the query is ran.
Confused as to the making the Login Screen invisible.
Thanks again
Good Morning,
I am sure that this has been asked many times and as I am knew to doing this extensive a db creating, I have a question for you.
I have a form that I am trying to get a couple of fields to auto populate based off of when the user logs into the db. The user logs into the db...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.