Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Signature pages of legal documents

Posted on 2013-11-15
4
338 Views
Last Modified: 2013-11-23
I create legal documents requiring signatures. I use visual basic 2010 / SQL to create workflows to collect data and print via crystal reports. Software runs as Windows application in inside a Domain. The documents are currently completely prefilled except for committee members signatures. I have been asked to report on technology needed to collect signatures for auditing purposes. We store physical documents at this time.

I would expect workflow to be something like...

1) Normal Document creation process
2) Meeting End
    Some action to collect signature for particpants in meeting (can be multiple of committee)
    Could be scan, picture, special device?
3) Merge collected signatures into document in correct signature places.  
4) PDF document after merging signatures onto document image.

I am in thinking mode and need idea's - please share thoughts.

So, How would you collect signatures on documents?

Any advice/suggestions/thoughts/idea are appreciated...
0
Comment
Question by:5teveo
  • 3
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39652441
Are you saying you want to have the committee members sign a document that hasn't been printed?

Do you have a way of securing the document so it can't be changed after it is out for signature?

How about a PDF that can be electronically signed either through a stylus device like we do for credit cards at the store or through a login/password when they click in the signature area.

You could capture all the signatures through a stylus device and store them in the database along with the report data.

Crystal can export to PDF and there are 3rd-party add-ons that can make some of the fields in the PDF available for data entry

http://www.milletsoftware.com/visualcutBenefit.htm

mlmcc
0
 
LVL 8

Author Comment

by:5teveo
ID: 39653902
Thanks for response!

Are you saying you want to have the committee members sign a document that hasn't been printed?
Answer: yes

Do you have a way of securing the document so it can't be changed after it is out for signature?
Answer: Yes, The document is crystal report until 'Uploaded' or 'Completed'... upon 'Completion' I store as a PDF. So future references of document as PDF views.

How about a PDF that can be electronically signed either through a stylus device like we do for credit cards at the store or through a login/password when they click in the signature area.
Answer: I like the idea as I'm creating a PDF now... I'm trying to determine if I must capture signature prior to PDF creation or afterwards... Workflow details is part of leaning curve for this particular action.  Login may not work so well as some users will not have logins since they are outside experts or participants.

You could capture all the signatures through a stylus device and store them in the database along with the report data.
answer: I like this plan of attack... placing graphics content like signatures on a crystal report may be a challenge.

Crystal can export to PDF and there are 3rd-party add-ons that can make some of the fields in the PDF available for data entry
Answer: But using a 3rd party follow-up tool for 'signature-time' on PDF is a very interesting workflow...

Thanks for link... i will review...

Still... Any other thoughts on PDF editing other than Adobe? I will explore Adobe form editing but I just want to ensure I have previewed out potential paths.
0
 
LVL 8

Accepted Solution

by:
5teveo earned 0 total points
ID: 39657408
Interesting solution here
http://thomasjbradley.ca/lab/signature-pad/

Plus
found another canvas solution on another solution site...
0
 
LVL 8

Author Closing Comment

by:5teveo
ID: 39671091
Thanks for thoughts and input
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question