Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Aug 2008
    Posts
    19

    Red face Unanswered: help make signature block for report?

    i have a database made from access 2003. we use it to track our fuel usage. the output is a weekly report that i sign and then take it to the boss for review and his signature. we are trying to get rid of having paper coppies stored in a binder. so what i would like to do is have electronic signature blocks on my report. like you can do with acrobat and infopath. we use smartcard ids to login to work computers and using the smartcard we can sign documents from both acrobat and infopath. now how do i get this to work?

    1. pre-make a form in acrobat or infopath with signature blocks then somehow populate data from access. maybe?

    2. infopath is office also, is there a way to make signature blocks show on my report?

    i dont know. any ideas?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Do you mean like a signoff eg:

    Kind Regards

    Fred Bloggs
    Manager
    SomeBusiness
    www.somebusiness.com


    If so, I have stored those kinds of things in normal text fields before and you can just access it the same way you would any other field.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2008
    Posts
    19

    Red face

    no i mean like digital signature on a document instead of signing with an inkpen. i want my report to have a digital signature block to sign with certificates from the smartcard. the reason i said acrobat and infopath is because i already know you can create digital signature blocks with both.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    its not safe or secure (even if your network trolls are on the ball), but you can include a facsimilie of the signature, by....
    scanning a copy of the signature,
    tidy it up if/as required in a graphics editing program,
    then assign the signature to a image/picture control (you can do it conditionally if required [ ie if fred blogs views it use his signature, if its someone else use their sugnature basd on the logon id]).
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by sumhungl0
    i have a database made from access 2003. we use it to track our fuel usage. the output is a weekly report that i sign and then take it to the boss for review and his signature. we are trying to get rid of having paper coppies stored in a binder. so what i would like to do is have electronic signature blocks on my report. like you can do with acrobat and infopath. we use smartcard ids to login to work computers and using the smartcard we can sign documents from both acrobat and infopath. now how do i get this to work?

    1. pre-make a form in acrobat or infopath with signature blocks then somehow populate data from access. maybe?

    2. infopath is office also, is there a way to make signature blocks show on my report?

    i dont know. any ideas?
    I know that the DoD was or is looking at using InfoPath to create such items as you wanted with using a smarcard certificate like FirstName.LastName.CertNumber on forms. They've got it to work using a program which I believe is also made by Adobe called "PureEdge" and "Salinas ApproveIT". However, those are for PureEdge forms. I think you could make your own MS InfoPath form to use MS Access data and insert a Signature block field like you want. I tried to create a "New Network User Request Form" in InfoPath. I gave up after it was too time consuming and I was pulling my hair out trying to get it to work the way I wanted it.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Every time I think of doing this, the following thoughts come to mind:

    1. The digital signature can be hacked or stolen and used for whatever.
    2. Many businesses will no longer accept such a signature because of 1.
    3. Since a digitally produced signature is not legally binding, is there any point in doing it?

    I tend to just have a button that an authorising user can click to authorise a record. The database can capture their username as the authorising user.

    However, you could store images in a user table in an OLE object field (cringe) and use them in forms and reports.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if the 'problem' is storing copies in a binder then contnue with your current process, but scan the document and save it electronically

    you still have the signoff procedure, you still have the audit trail that A & B have signed the document

    anything else is in my books prone to fraud, r looes the whole point of the signature in the first place.. ie there is no proof that anyone has reviewed the document.
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Aug 2008
    Posts
    19

    Wink you are missing the point...

    there is no reason for fraud here. there is such a small amount of people who use this database and really why would anybody want to mess with this procedure anyway? the point here is to make it easier for all who use it. fraud is not really an issue here.

    now as far as Grafixx is talking about is exactly what i want. that idea of making a form from infopath with a signature block on it, and somehow pull the report data from access. or if it makes it any easier, make a form from acrobat with a signature block and get the data from access report or querys.

    im sorry if im unclear on any of this, im trying to explain it the best i can. thanks for the input so far.

  9. #9
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    'just' scan a signature into a file eg a JPEG or TIFF
    tidy the signature if require din a graphics program (remove any scanner artitfacts)
    insert the scanned signature into picture/image control.. you could do this conditionally based on the logged on user ID. ie examine the network logon id and select an appropriate signature image
    I'd rather be riding on the Tiger 800 or the Norton

  10. #10
    Join Date
    Aug 2008
    Posts
    19

    maybe

    that is not what i want, but it might work well enough. can you explain in some detail how i could do this? does the signature image need to be on the boss's local machine or can it be just on the server with the database? i can edit the image to look perfect thats not a problem. what would i do with the report, make a button to sign the report? not sure how that part would work. i email the report to the boss, then how does he sign it?

    thanks for the help!

  11. #11
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by sumhungl0
    that is not what i want, but it might work well enough. can you explain in some detail how i could do this? does the signature image need to be on the boss's local machine or can it be just on the server with the database? i can edit the image to look perfect thats not a problem. what would i do with the report, make a button to sign the report? not sure how that part would work. i email the report to the boss, then how does he sign it?

    thanks for the help!
    If you use the scanner to scan the signature, you'll have to resize it and save it as a jpg or other image file type that MS Access allows you to import using an OLE.

    You're best bet would be to store the persons signature on THEIR machine under THEIR name just so people (though you said you're not too worried about it) won't go and put in like the bosses signature WITHOUT the boss actually saying it's approved or whatnot.

    Like you said though, Adobe Acrobat WILL allow you to develop your own form and insert a signature block into it, but InfoPath will also allow you to do this. If you're using the SmartCards like the Department of Defense is, you'll need the ActiveClient and Salinas ApproveIT software to accomplish putting in the persons signature certificate information into it which is actually easy once you have the programs installed.

  12. #12
    Join Date
    Aug 2008
    Posts
    19

    i have the software

    i have activeclient. the problem is i cant combine the two things i need together.

    1. i have a report from access
    2. i have both acrobat pro and infopath, and know how to make the form's signature block to be used with smartcards and activeclient

    how can i bring the two together?

    thats why i was asking if there is a way to automaticly fill an acrobat or infopath form with my access report data or query data for that matter. or the other way around, make the form to get the data from the access report or query. thats what i dont know, how to link the two.

  13. #13
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by sumhungl0
    i have activeclient. the problem is i cant combine the two things i need together.

    1. i have a report from access
    2. i have both acrobat pro and infopath, and know how to make the form's signature block to be used with smartcards and activeclient

    how can i bring the two together?

    thats why i was asking if there is a way to automaticly fill an acrobat or infopath form with my access report data or query data for that matter. or the other way around, make the form to get the data from the access report or query. thats what i dont know, how to link the two.
    Have you looked into getting the software "Salinas ApproveIT"? That's what we HAD to have in order to import the signatures off the SmartCards of the users. Here's their company website.

  14. #14
    Join Date
    Aug 2008
    Posts
    19

    activeclient works fine

    i can inport with activeclient, i can already sign forms with the smartcard. i just need to sign my report the same way.

  15. #15
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by sumhungl0
    i can inport with activeclient, i can already sign forms with the smartcard. i just need to sign my report the same way.
    Then my guess is that you'll have to try to figure out how to insert a signature field OR try to export the report into Adobe Acrobat and see if you can insert the signature block field

    But I think that making an InfoPath page and sending the MS Access report data to that page would be easier.

Posting Permissions

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