Capture Customer Signature (1 Viewer)

Learn2010

Registered User.
Local time
Today, 04:42
Joined
Sep 15, 2010
Messages
415
I have read a lot of information about capturing customer signatures in an Access database and am still confused. Here is what I need to do.

I want to use a laptop computer and let a customer sign a form and store that in an Access database. I would probably pull the data out to a clean table behind a form, fill in new data, have the customer sign the form on-screen, and save it. To keep the database size down, I would store the signatures in an external database and link to it for future use.

Now, I am looking for the various combinations available to accomplish this.

1) Is there a computer that will accommodate this entire process? Or,
2) Do I need a certain kind of computer and peripheral equipment, such as a signature pad? Or,
3) Do I need any computer and peripheral equipment, such as a signature pad? Or,
4) Do I need special code? Or
5) Do I need a combination of some of the above?

If you have had success with this, please let me know.

Thank you.
 

isladogs

MVP / VIP
Local time
Today, 09:42
Joined
Jan 14, 2017
Messages
18,212
Hi

See 2 examples attached
a) SignatureCapture - does what it says on the tin
b) InkText - saves 'handwritten' words as text

You can use a mouse. trackpad or touch screen to input signatures/words

1) Is there a computer that will accommodate this entire process?
Any Windows PC with Access.
I have used both of these successfully on a Windows tablet ... so its portable

2) Do I need a certain kind of computer and peripheral equipment, such as a signature pad? No but these are available as an alternative
3) Do I need any computer and peripheral equipment, such as a signature pad? Same as qu2
4) Do I need special code? You need ActiveX controls and code similar to the examples
 

Attachments

  • InkText.accdb
    504 KB · Views: 201
  • SignatureCapture.accdb
    520 KB · Views: 246

Learn2010

Registered User.
Local time
Today, 04:42
Joined
Sep 15, 2010
Messages
415
Thanks a great deal for your quick response.

1) The trackpad allows you to use your finger?

2) Is the trackpad a peripheral or part of the computer.

3) I assume you would put the cursor into the field where you want the signature, get the signature, and save it. What kind of field is it?
 

isladogs

MVP / VIP
Local time
Today, 09:42
Joined
Jan 14, 2017
Messages
18,212
1) The trackpad allows you to use your finger? yes but its much harder to use than a mouse or touch screen.
A stylus would also work on a touch screen (or a biro cap etc ....)

2) Is the trackpad a peripheral or part of the computer. Built in - laptop

3) I assume you would put the cursor into the field where you want the signature, get the signature, and save it. What kind of field is it?
All the info you need is in the examples


There's another nice example here:
http://www.accessmvp.com/thedbguy/demos/signature.asp

NOTE: The tablet I've used this on has a 10" screen (Linx 1010)
I don't have a smaller Windows tablet but in theory as long as you can install Access, it should also work on a 7" screen (or possibly a Windows phone????)
 

Learn2010

Registered User.
Local time
Today, 04:42
Joined
Sep 15, 2010
Messages
415
Thanks, again. That is enough to get me where I need to go.
 

Users who are viewing this thread

Top Bottom