I'm trying to create a way for an employee to electronically 'sign' off on a job offer. My plan is for the employee to enter their ID and Password. Access will then compare their password input to the password database. If it's a match, their *.bmp signature (in a separate table) will be placed in a box for all to see.
How can I compare the employee's input password to their actual password from another table? And then, if they match, place a BMP image of their signature on the form?
Would that be some form of an IIF?
That way, when someone "signs off" on the job, everyone viewing the form will see their signature authorizing it. Obviously, if the passwords don't match, then no signature.
Supervisor enters his ID
Supervisor enters his password
Access verifies (compares) his ID & password
If true, returns the employee's signature image to the form (each employee has his own signature)
If false, "You are not authorized to sign this"
I'm an advanced user/designer in 2003, but also have 2007 and 2010 available.