Hello. Is there's a way to set up a cell (used as a signature box) in Access to take in a secret code (per user) that gets matched up with their corresponding signature (initials)? Example, Mike Smith can't just enter MS. He would enter his code 5XR4T when he does MS will appear in the signature box. Is this possible? I need to be able to offer a way of preventing other users from entering someone else's initials in the signoff box. And I figured if there's a way to set up each user with their own secret code that they enter, instead of their initials that would help. I know this is a strange question. Thanks in advance.
Added layer of security for a signature box
- Thread starter sheckay
- Start date
- Local time
- Yesterday, 18:14
- Joined
- Aug 30, 2003
- Messages
- 36,194
Not a strange question, I've got a client that does something similar. Clicking a button to "sign" the document triggers an input box to enter a password. That entry is compared to the user's password stored in an employee table (you can use a recordset or DCount). If valid, the user's signature is added, if not an error is returned.
- Local time
- Yesterday, 18:14
- Joined
- Aug 30, 2003
- Messages
- 36,194
And now I see this has been crossposted:
excelguru.ca
Security layer to signing off with initials
Hello. Is there's a way to set up a cell (used as a signature box) in Access to take in a secret code (per user) that gets matched up with their corresponding signature (initials)? Example, Mike Smith can't just enter MS. He would enter his code 5XR4T when he does MS will appear in the signature...
www.accessforums.net
A message to forum cross posters
Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →
excelguru.ca
Sorry. I wasn't aware of this being a problem. But, yes, I posted this same question in another forum in hopes of getting help.And now I see this has been crossposted:
Security layer to signing off with initials
Hello. Is there's a way to set up a cell (used as a signature box) in Access to take in a secret code (per user) that gets matched up with their corresponding signature (initials)? Example, Mike Smith can't just enter MS. He would enter his code 5XR4T when he does MS will appear in the signature...www.accessforums.net
A message to forum cross posters
Do you know why you're here? If you have been pointed to this page, it is not because someone is mad at you, but rather because we want to curb your posting habits before people start ignoring your posts. Online … Continue reading →
Wow, thank you for that info. I'll have to look into that and see if I can figure out how to make that happen. Thanks for pointing me in the right direction.
- Local time
- Yesterday, 18:14
- Joined
- Aug 30, 2003
- Messages
- 36,194
No worries, it's just a courtesy. That second link explains it better than I can.
I posted this to another forum (https://www.accessforums.net/showthread.php?t=89285 ) and someone (moke123 ) has given me an example file with code. And it took me a little while to get it going. Then a little while to figure out how it works. But I think I'm going to try to implement that solution. It sounds similar to yours, but slightly different in some ways. So I would like to figure out your recommendation one of these days. But I thank you for pointing me in that direction!!
Similar threads
