First time user and poster. Thank you for the acceptance into the community.
I am not very proficient with Access but I will try to use as many of my resources as possible before asking for assistance. At this point I just have no clue as to how to accomplish what I would like and have run into a brick wall when searching with google for examples.
I have a table that contains the following fields:
I then have a form that requires a user to put in their username/password for their name to be entered into the specific field automatically. The code I pasted below does a great job and works. Unfortunately, I have a total of 4 fields that require the same type of username/password entry verification and the same person may sign off more than one field. In order to address this, I have made a seperate table/username for each field. I know there is a more efficient way to accomplish this, I just do not know how.
What I would like to have is one table with the following fields.
PrimaryID(AutoNumber), WorkerName(txt), WorkerPassword(txt), Technician (txt), QualityControl(txt), Supervisor(txt), MaintenanceSupervisor(txt). The last four fields would be a yes or a no stating if the person is authorized to make that entry. If the field value is yes, the rest of my code would run. If the entry in the field is No, then a MsgBox would popup saying that they are not authorized to sign the appropriate entry.
Any help would be appreciated. I know I would have to change the coding slightly for each field that requires validation. Which are:
Field one = Technician
Field two = Quality Control
Field three = Supervisor
Field four = MaintanceSupervisor