Currently I am working on a database that I am trying to use password authentication.....
.mdb file - Password authentication is working and I can get it to send the login ID over to the form. With the form I am going to use it to make record entries for a specific user that is logged in. Criteria needs to be based on the employees name and current date (date() already set). But all it is displaying is the Employee ID instead of the Employee Name.
So what I am needing is not only to display the Employee name, but set it as the value of the text box when the form opens so I can use it inconjuction with the query. The control source of the form is the query, so when it comes up, i want it to already check and see if there is data for that employee for the same date, and allow them to update it so it updates the record.
I have attached the database. Please advise of a different method of VBA coding or something specifically that should be changed. Before I tried this method I was going to use global variables to define the user id as a global variable. At that point I could make it display the user but not use it as criteria for the query. Is there a way to have the query use the global variable as criteria outside of the form since the global variable would have already been defined? Which ever way would be easier, that is what I am about. Please help if possible. .. thank you very much for the help.