Results 1 to 8 of 8
  1. #1
    ddansie is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    5

    Signature box in form (Access 2016)


    In Word 2016 there is a way that you can put in a signature box that you can use on a "tablet" type of device to get a persons signature. Is there a way in an Access 2016 form to do the same? I have looked all over the Internet and can't find anything with the exception of one place that wants to sell you their code. I am hoping that that is not the only way that I can do this.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    Word has graphic tools not available in Access.

    You could have a graphic file (png, jpg, bmp) of each person's signature. Then load the image onto form or report with an Image control.

    I expect the 3rd party app is interfacing with a graphic application that saves signature to an image file and loads that file to control on form or report. So every time user signs a record, there is a new image file created. The filename of that image file would be saved into record or the image file embedded into an attachment type field. If embedded, likely the external file is deleted.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ddansie is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    5
    How sad! Now I'm not sure what I am going to do about that.

  4. #4
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Quote Originally Posted by ddansie View Post
    How sad! Now I'm not sure what I am going to do about that.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    I have not viewed this YouTube but maybe it will offer something https://www.youtube.com/watch?v=m3IMLn11j90

    and the following which appears to be VisualStudio code (vb.net ?). No idea if the control is available to Access.

    https://msdn.microsoft.com/en-us/lib...or=-2147217396

    and this discussion

    https://it.toolbox.com/question/stor...atabase-031407
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    ddansie is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    5
    The video is the only one that I found, but they want to charge you $100 for their "template". I will look into the VS code see if I can make that work.

    Thank you for your help.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,926
    $100 might be a reasonable investment compared to value of your time to develop the same thing, if the template allows access to all code.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    In this case $100 is an unnecessary expense.

    See this thread for two examples - one that I created myself and another by the dbguy
    https://www.access-programmers.co.uk...nature+capture


    Click image for larger version. 

Name:	Capture2.PNG 
Views:	10 
Size:	15.6 KB 
ID:	33074

    I also included an InkEdit example where handwritten input is changed to text
    All examples include code

    I also include my code to collect customer signatures as a feature in my UK Postal Address Finder database
    http://www.mendipdatasystems.co.uk/u...der/4594138311
    It's a commercial app but a free evaluation version is available
    Last edited by isladogs; 03-14-2018 at 08:00 PM. Reason: added screenshot
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. PIV (Government) Digital signature in Access field?
    By securitywyrm in forum SharePoint
    Replies: 2
    Last Post: 01-04-2018, 12:21 PM
  2. Automating Outlook 2016 from Access 2016
    By jcc285 in forum Programming
    Replies: 10
    Last Post: 09-30-2017, 01:53 PM
  3. Save ink signature from form to table
    By valdezmg in forum Access
    Replies: 3
    Last Post: 08-13-2015, 11:46 AM
  4. Replies: 7
    Last Post: 11-27-2013, 08:37 AM
  5. Add Signature Box in a form
    By kowsigan in forum Forms
    Replies: 1
    Last Post: 12-20-2010, 03:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums