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,727
Joined: 14-March 00
From: 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

--------------------
Cheers,
John
Go to the top of the page
 
cheekybuddha
post Feb 21 2018, 06:01 AM
Post#2


UtterAccess VIP
Posts: 9,974
Joined: 6-December 03
From: Telegraph Hill


Maybe our own top poster extraordinaire can help?

--------------------


Regards,

David Marten
Go to the top of the page
 
johnpdmccall
post Feb 21 2018, 07:16 AM
Post#3



Posts: 1,727
Joined: 14-March 00
From: Scotland


Wonderful! Thanks CB and DBG!! notworthy.gif

--------------------
Cheers,
John
Go to the top of the page
 
cheekybuddha
post Feb 21 2018, 07:18 AM
Post#4


UtterAccess VIP
Posts: 9,974
Joined: 6-December 03
From: Telegraph Hill


Nowt to do with me! All kudos to the big green guy!

--------------------


Regards,

David Marten
Go to the top of the page
 
LPurvis
post Feb 21 2018, 09:14 AM
Post#5


UtterAccess Editor
Posts: 16,271
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,727
Joined: 14-March 00
From: 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?


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



Posts: 1,727
Joined: 14-March 00
From: 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.

--------------------
Cheers,
John
Go to the top of the page
 
LPurvis
post Mar 2 2018, 11:36 AM
Post#8


UtterAccess Editor
Posts: 16,271
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,727
Joined: 14-March 00
From: Scotland


Thanks for the reassuring reply Leigh!

--------------------
Cheers,
John
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    21st June 2018 - 08:43 PM