Search results

This is amazing, thank you! The last bit of assistance I need is the input mask for the following: 123456-500 and 123456-500ABC. I cannot seem to get the field to accept these type of entries. Thank you very much Ms. Hartman.

Ms. Hartman, I did as you stated above. The issue I am having is that I need all of the "data" to load in the subform for every employee as a default. I am unsure on how to accomplish this? Basically there is a core of processes that every employee is taught by product. The leads use this as...

My apologies I failed to add EmpID to the 2nd table, please see my correction above, thank you.

So would this permit the information to be available in the subform? I have several to add and need their leads to be able and update their status if they are In Training, Proficient, for every Task. Thank you

Hello! Can you please advise on how I could have the following show up by default in the subform for every single person? I have (1) table with: Firstname LastName EmpID The second table with: EmpID AntennaType AssemblyNumber TaskName Here is an example of the data: Thank you for the help!

Display the values. What I am trying to do is create a repository to capture certifications by employee. So when a particular cert is chosen, the end user needs to see area and description.

What I mean is, Id like to offer the certs as a list and when a particular cert is selected, I need the Process Area and Description to be tied to it so it can be seen upon selection. At some point I would like to query which certs are available by area, etc.

Hello, I would like for the Process Area and Description to auto populate based on what I enter under Cert Code. I am unsure how to do this with a List Box? Appreciate the support, thank you

:love: Thank you!!!!

Hello, would the following assist me following your directive? https://www.creativeconnections.co.uk/how-to-lock-a-text-box-on-an-access-form-how-to-unlock-a-text-box-on-an-access-form/

Well Ms/Mrs Hartman I look forward to trying to enforce the use of unapproved pronouns. We have so many greater challenges in this world and this is what we want to focus on? Sad.... Thank you very much for your advise and support of my access questions. :)

Corrected, my apologies.

Hello Mrs Hartman, so yes by department makes sense versus supervisor. Other supervisors would not be allowed to access another supervisors employees, except for the superuser. How do you suggest the override? Thanks

Its an employee database that will only show employees by supervisor. So in essence, when Supervisor A or B login, they should only be able to see their assigned employees. Then I need a superuser who can see all employees. I just need to understand how to accomplish this...

Hello, I need to develop an access database that will only allow users to see records based on their login. Could someone please refer me to a sample database, video, etc on how to get this done. Thanks you

What you just described would be ideal! I'm aware this is access and not excel, but I lack the expertise. Can you point me to some material or a video that may assist me in doing exact what you just said! As you said, I don't need or want to "tie" the information by supervisor, so I changed...

I have a database with a: (form, table, and subform) for each MFG Supervisor. The Prod Manager does not want the supervisors to have access to each others employee information. How would I then create a query that will run a report to capture the data from the various supervisors under (1)...

Could you direct me to the code please, thanks.

Yes thank you. I guess i will print to PDF then from there send it to email. Just would be nice to do it directly from Access.