Capture Customer Signature using MS Access on Tablet PC
I have an application being developed with MS Access 2003 and SQL Server for a Tablet PC. I need to capture an inspection customer's signature each time the inspection is performed. I then need to store the signature in a SQL database. Later, the signature needs to be recovered and displayed on an Access Form and Access Report. The signature does not need to be encripted but should be smoothed. Does anyone have the VBA code and controls to accomplish this. I am not familar with calling a .net application if that is needed to accomplish this. I am looking for the complete solution.
conagraman
sounds like identity fraud
ASKER
Conagraman,
If you or someone else has a solution that can encrpt, that is fine. I need to capture the signature of the store manager, print him a copy of the report immediately, transmitt the info back to the server and then print and email the report to the property owner with the manager's signature. Just like it would be on a copy or our current manual report.
If you or someone else has a solution that can encrpt, that is fine. I need to capture the signature of the store manager, print him a copy of the report immediately, transmitt the info back to the server and then print and email the report to the property owner with the manager's signature. Just like it would be on a copy or our current manual report.
ASKER
Conagraman,
I have looked at this document before and downloaded the samples. I can run it but I am not that familar with VB projects and how to build controls This is exactly what I want to do, plus save the signature to the database when the user clicks "Accept". I also need to be able to retrieve the signature from the database to print via a MS Access form. I would also need to be able to resize the signature graphic on the report.
I have looked at this document before and downloaded the samples. I can run it but I am not that familar with VB projects and how to build controls This is exactly what I want to do, plus save the signature to the database when the user clicks "Accept". I also need to be able to retrieve the signature from the database to print via a MS Access form. I would also need to be able to resize the signature graphic on the report.
No takers yet? Bummer. Let me see what I can come up with.
This Access app will b e running directly on the tablet correct?
JimD.
This Access app will b e running directly on the tablet correct?
JimD.
ASKER
Yes, half of the app has already been developed. I plan on installing the runtime version on the talets. I was counting on a product from Topaz SigPlus Tablet but it does not work. It will capture and encript the signature but the current version won't won't print the signature. The previous version will print the signature but not capture it.
What OS is on the tablets?
JimD.
JimD.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved the problem myself with the code in the last note from me.
<<I was finally able to resolve this myself with the following code.>>
Excellent. Nice work.
<<Now I am researching how to print the image directly from the database rather than a local file. That would work a lot better for my app.>>
Look at the methods for the MSINKAUTLib. There should be some method to load a signature. It has the save method:
bytArr = objInk.Ink.Save(2)
I would think there would be something to load it back into the control.
Barring that, the finial image is a .gif format and there should be plenty of code floating around on how to manipulate that.
and of course if push comes to shove, read it from the DB and write it to a temp file, then load/print as needed and kill the temp file off after that.
JimD.
Excellent. Nice work.
<<Now I am researching how to print the image directly from the database rather than a local file. That would work a lot better for my app.>>
Look at the methods for the MSINKAUTLib. There should be some method to load a signature. It has the save method:
bytArr = objInk.Ink.Save(2)
I would think there would be something to load it back into the control.
Barring that, the finial image is a .gif format and there should be plenty of code floating around on how to manipulate that.
and of course if push comes to shove, read it from the DB and write it to a temp file, then load/print as needed and kill the temp file off after that.
JimD.
inkPicture Control from form tools to enter the customer signature.
Did you find errors in the above control when you tried to destribute it?
I have that problem- I have a solution but can't distribute it very easily.
any comments would be great.
thanks Frank
Did you find errors in the above control when you tried to destribute it?
I have that problem- I have a solution but can't distribute it very easily.
any comments would be great.
thanks Frank