Results 1 to 4 of 4
  1. #1
    Barry is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Sep 2010
    Posts
    2

    Question compare password entered to DB then place signature BMP

    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.
    Last edited by Barry; 09-21-2010 at 04:37 PM. Reason: clarification

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    That's a good plan Barry. What question are you trying to ask though?

  3. #3
    Barry is offline Novice
    Windows 98/ME Access 2003
    Join Date
    Sep 2010
    Posts
    2

    modified question

    Hi ajetrumpet,

    Thanks for showing me my error. I have edited the question to actually show the question.

    Barry

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    If you've been using Access for awhile, then you should be familiar with general conditional statements. checking of the password is done by a conditional combined with a DLOOKUP() function. After that, I would assume a simple image control on the form that could be visualized would be fine. Do you have one yet? Put one on there and make it invisible (with no source) until a PW match is found, then issue the path and set the picture type as embedded. Those properties are located in the intellisense dropdown list of an image control once you reference it with "me.control."

Please reply to this thread with any new information or opinions.

Similar Threads

  1. scanned signature(s) on a report
    By thedoc44 in forum Access
    Replies: 7
    Last Post: 09-15-2010, 10:54 PM
  2. score and place query
    By ymds in forum Queries
    Replies: 1
    Last Post: 06-10-2010, 06:07 PM
  3. Replies: 1
    Last Post: 05-21-2009, 08:13 AM
  4. Replies: 0
    Last Post: 02-21-2008, 09:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums