Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cjdecou

    Auto Populate fields based on Log In screen

    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...
  2. cjdecou

    Auto Populate fields based on Log In screen

    Sorry, thank you for being so patient. The control is a text box
  3. cjdecou

    Auto Populate fields based on Log In screen

    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...
  4. cjdecou

    Auto Populate fields based on Log In screen

    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" &...
  5. cjdecou

    Auto Populate fields based on Log In screen

    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...
  6. cjdecou

    Auto Populate fields based on Log In screen

    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...
  7. cjdecou

    Auto Populate fields based on Log In screen

    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...
  8. cjdecou

    Auto Populate fields based on Log In screen

    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.
  9. cjdecou

    Auto Populate fields based on Log In screen

    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...
  10. cjdecou

    Auto Populate fields based on Log In screen

    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
  11. cjdecou

    Auto Populate fields based on Log In screen

    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...

Part and Inventory Search

Back
Top