Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Ms Access 2010 and InkPicture control

Posted on 2014-09-07
15
Medium Priority
?
1,525 Views
Last Modified: 2014-09-15
With a tabletpc I need to save customer signature.
I'm considering to use microsoft activex inkPicture control.
Does anyone have any example ?
thanks in advance
marco
0
Comment
Question by:marcozamperlin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
15 Comments
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40309189
I made a sample database using this control in  another thread.  Check it out and see if it would suit your needs.

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28218072.html#a39436639

Ron
0
 

Author Comment

by:marcozamperlin
ID: 40309373
Thanks Ron,
The example I had seen it, sadly lacking how to use the signatures in a report ...
Can you have any idea ?
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40318617
Okay, here's a revised demo that has signatures in a report.  One quirk I haven't been able to figure out is after signing once, you have to reopen the form to sign again.  Other than that, it seems to work without any problems.

Ron
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:marcozamperlin
ID: 40318826
Thanks Ron! Do you know a way to check if it was written signature?
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40319218
I don't understand what you mean by written signature.
0
 

Author Comment

by:marcozamperlin
ID: 40319284
Sign: a person's name written in a distinctive way as a form of identification in authorizing a check or document or concluding a letter.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40319301
Still not sure what you mean.  Do you mean to check a signature against one that's on file?  If so, I don't know how you would do that.
0
 

Author Comment

by:marcozamperlin
ID: 40321550
I have another problem: I created a report with a InkPicture control. In report view mode, the signature is displayed correctly while in print preview mode no. Do you have any idea?
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40321775
Are you certain about which view it displays correctly in?  Print Preview is where it you should see the signatures since this is the view that shows what it would look like when printed.  Report view does not fire events so you wouldn't see the signature there.
0
 

Author Comment

by:marcozamperlin
ID: 40321978
I have write this code:

Option Compare Database
Option explicit

Private Sub LoadSignature()

Dim newInk As New InkDisp 'need new object to load new ink
   
    If Not IsNull(Me.Sign) Then
        newInk.Load (Me.Sign)
        Me.InkDisplaySig.Ink.DeleteStrokes
        Set InkDisplaySig.Ink = newInk

    End If
    InkDisplaySig.AutoRedraw = True
End Sub

Private Sub Body_Print(Cancel As Integer, PrintCount As Integer)
      LoadSignature
End Sub

Private Sub Report_Load()
      LoadSignature
End Sub

Sign is the Ole field.

In report view the signature is displayed.
In print preview not.
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40322161
You need to follow the sample db I gave you.  Look at the OnFormat event of the detail section of the report.
0
 

Author Comment

by:marcozamperlin
ID: 40322509
Your sample that I have does not have a report but only a table and a form ...
0
 
LVL 29

Accepted Solution

by:
IrogSinta earned 2000 total points
ID: 40322526
Oops, I thought I uploaded my revised demo in my second post.  Sorry about that.  Here it is:
SignatureInk.accdb
0
 

Author Comment

by:marcozamperlin
ID: 40322576
This version works well. Question: Is it really necessary to use a temporary file?
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 40323160
It may be possible to do without the temp file, perhaps with the Renderer() method.  Unfortunately there aren't that many examples provided out there in order to figure out how to do this.  

Ron
0

Featured Post

The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Six Sigma Control Plans

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question