X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Collect Hand-written Signatures, Access 2010    
post Sep 15 2016, 11:02 AM

Access Wiki and Forums Moderator
Posts: 74,201
Joined: 19-June 07
From: SunnySandyEggo

UtterAccess member ebwhittaker provided the original concept for this demo. Thanks, Ed!

Many UA users have expressed the need to collect signatures from their clients through their Access application. Some users are already using tablets or smart phones to run their Access application, which provide a perfect input device for collecting hand-written signatures and storing the signature information with the data.

The attached demo uses an ActiveX control to display a form for collecting the signature from the user. The signature information is then stored in the table and later displayed with the record. Please note the raw data is stored in a Memo field, which may look like Chinese characters if you open the table. I decided to use a Memo field to reduce file bloat. It is used with the Image Control when you implement this technique without using an Attachment Field. Otherwise, using an Attachment Field will not require the use of the Memo field.

The demo shows two ways to display the signature on a form: by using an Image Control or a an Attachment Field

I also tried to display the signature using the same ActiveX control but found it to work intermittently. I also tried storing the signature data in an OLE field and then use an OLE Object Control to display it but was not successful because I couldn't figure out the correct image format for the OLE Object control. If anyone figures out how to do the above, please let us know, so we can all learn from it.

I hope you find the attached demo somewhat useful.

Again, I would like to thank Ed for sharing his experience and success using this technique.


Note: This demo was designed using Access 2010 and tested using Access 2010 and 2013.
Attached File(s)
Attached File  theDBguyCollectSignatureDemoV1.0.zip ( 56.84K )Number of downloads: 339
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    20th January 2019 - 04:13 PM