UtterAccess.com
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
> Real Written Signature In Access, Access 2016    
 
   
johnpdmccall
post Feb 21 2018, 05:53 AM
Post#1



Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland


Hi Folks,

I want to collect a patient's signature on a consent to treatment form somehow in Access:
Either: Directly into an Access field via a touch screen (like you do when accepting a parcel delivery at home)
OR: Into a document (eg word) via a touch screen, then display the document by clicking a button on the patient record (Access form).

Any ideas if there is a field in access that will accept touchscreen input of a signature or if there is some way to achieve this that looks smooth and easy to the user?

Thanks for any help
Go to the top of the page
 
cheekybuddha
post Feb 21 2018, 06:01 AM
Post#2


UtterAccess VIP
Posts: 10,626
Joined: 6-December 03
From: Telegraph Hill


Maybe our own top poster extraordinaire can help?
Go to the top of the page
 
johnpdmccall
post Feb 21 2018, 07:16 AM
Post#3



Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland


Wonderful! Thanks CB and DBG!! notworthy.gif
Go to the top of the page
 
cheekybuddha
post Feb 21 2018, 07:18 AM
Post#4


UtterAccess VIP
Posts: 10,626
Joined: 6-December 03
From: Telegraph Hill


Nowt to do with me! All kudos to the big green guy!
Go to the top of the page
 
LPurvis
post Feb 21 2018, 09:14 AM
Post#5


UtterAccess Editor
Posts: 16,296
Joined: 27-June 06
From: England (North East / South Yorks)


Hi

Just passing and glad you've got a solution.
Just to mention, this has been brought up over time and there are other alternatives (such as not needing an ActiveX control... which is a considering always worth...well... considering.)
http://www.UtterAccess.com/forum/index.php?showtopic=2037298

Cheers
Go to the top of the page
 
johnpdmccall
post Mar 2 2018, 09:32 AM
Post#6



Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland


OK I've got that working great in a split database. Thanks for the help so far :-)

Now I'm trying it with the tables on Azure SQL and getting errors consistently in the on click event of cmdAccept on frmSignature
It highlights this line:
CODE
Set rs2 = rs1.Fields("SignatureFile").Value


I'm wondering if it is something in the migration from access table to SQL that is the problem?
Any ideas?

Go to the top of the page
 
johnpdmccall
post Mar 2 2018, 10:01 AM
Post#7



Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland


OK I think I've answered my own question which is Yes - SQL converted the image field to Long Text. However I don't want to save the signature as an attachment but as data, so no matter, I simply commented out the relevant code.
Go to the top of the page
 
LPurvis
post Mar 2 2018, 11:36 AM
Post#8


UtterAccess Editor
Posts: 16,296
Joined: 27-June 06
From: England (North East / South Yorks)


Hi

Not being familiar with DBGuy's version, I see:
Set rs2 = rs1.Fields("SignatureFile").Value
and assume that he's used an attachment data type? That does indeed have no SQL equivalent data type.
You'll probably want to insert that byte array into the data field more directly rather than load it from a file. (This is an inherent advantage in using the native Access image control - its binary data is directly applicable to the control.)

How you choose to work with the binary data (extracting it back out to a file may be necessary I imagine, before you can then assign that image file to the ActiveX control.)

All a bit of a faff. Hence my preferring the native Image control. :-)

Cheers
Go to the top of the page
 
johnpdmccall
post Mar 2 2018, 12:00 PM
Post#9



Posts: 1,770
Joined: 14-March 00
From: Ayrshire, Scotland


Thanks for the reassuring reply Leigh!
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    14th December 2018 - 01:02 AM