Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    code initialing (2000 9.0.3821 SR-1)

    We have an Access program for recording some checks written on customer's accounts. A manager must approve the check. Of course, on a computer, anyone could type anyone's else's initials to authorize the check. So is there a way to have a cell for the "initials" behave this way: Each manager would have a pass code (3-4 digits), when on the cell that asks for initials, they would type their secret code, which would not be displayed on the screen. After a recognized code was entered, that manager's initials would appear. This would work like a secret "auto correct". By typing one thing, another is displayed.

    If there is a different way to allow a person to uniquely and securely "ok" something, I'm open...

    Thanks
    Rick

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: code initialing (2000 9.0.3821 SR-1)

    You'll have to use Access User Security.
    If you don't, you can write all sort of code with passwords and other stuff but what will prevent a user to enter the initials in the tables directly ?
    For a start with user security have a look at :
    <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp>Frequently Asked Questions About Microsoft Access Security for Microsoft Access versions 2.0 through 2000
    </A>
    or do a search on the lounge for security. There are a lot of threads about it.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: code initialing (2000 9.0.3821 SR-1)

    I'm sure there's probably an answer for your proposed method, but it's apt to be a tad complicated.

    I'd have a separate field for the manager's pass code. Set the input mask to "Password" (without the quotes).

    If you really want to display initials (perhaps to let other people see who authorized it), then set that the initials field in the after update event code of the pass code field and make sure the initials field is locked.

    Make sure you create an MDE of your database to cut down on hacking, and workgroup security probably isn't a bad idea as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •