Signature required on a report

The company I work for has a MS Access based system that keeps track of the work we do but a new government regulation makes it necessary for supervisors to sign a certificate confirming jobs have been checked. Generating the certificate (Report) from the Access system will be easy but I am looking for ideas on whether it's possible to generate it in a format that the user can sign on a mobile phone and email back to us. I know that there is some way of inserting a signature field in a PDF but I don't know what is needed to do that from MS Access. Or is there an alternative?
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can create a PDF from an Access report, but as far as showing it on a phone, you'd have to use 3rd party software to do that (and most likely some sort of custom application, if you want the phone to automatically email it somewhere after signature). Access can work on phones, but you must use a Web App, or some sort of 3rd party RDS type of system. Even then, it's not well suited for phone use.
0
frankhelkCommented:
A signature in an PDF is a pice of cryptographic data embedded into the PDF file. More precise it's a checksum over the document and a timestamp, encrypted with the secret key of the signer. That could be decrypted with the corresponding public key and allows to verify that the document is approved and unchanged since signing.

To handle that, you'll need to use some PDF management library which allows to manage signatures. Yo'll have to knit that into vour Access code and the signing app on the mobile
0
Rob4077Author Commented:
Probably more complex than I need. Perhaps if I clarify what I was hoping to achieve.

After the job is completed the supervisor needs to visit and check to confirm it's done. I was hoping to be able to email him a pre-filled report containing the required data for him to date and sign. Problem is that to make use of it he needs to be able to print, sign and either return the hard copy or photograph it and return. We then need to email that to the customer. I could "cheat" and add a JPEG of his signature on all reports once he's verified they're correct but I would prefer his signature (low tech JPEG or alternative is fine) on the document. I have been told iPads have some way of inserting a simple signature field and I think even Google Forms has the provision. I was hoping there would be some easy-ish way of doing it with a PDF form. I think I have received PDF forms before that I could sign on my phone, save and return to sender.

Sounding like it's not an option
0
PatHartmanCommented:
I keep scanned signatures in a secured folder.  When someone "approves" something, I prompt them for their approval password and then I update the record with their approval datetime and add the name of their signature file to the document so it prints in a bound object frame.  Until the document is approved, the Bound Object Frame has no file name and so prints empty.

You could handle the exchange by email.  The user just needs to be able to confirm he is who he says he is.  Then you can embed his signature electronically.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rob4077Author Commented:
Cool. That will work. Thanks Pat
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Mobile

From novice to tech pro — start learning today.