Ms Access 2010 and InkPicture control

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
marcozamperlinAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

IrogSintaCommented:
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
marcozamperlinAuthor Commented:
Thanks Ron,
The example I had seen it, sadly lacking how to use the signatures in a report ...
Can you have any idea ?
0
IrogSintaCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

marcozamperlinAuthor Commented:
Thanks Ron! Do you know a way to check if it was written signature?
0
IrogSintaCommented:
I don't understand what you mean by written signature.
0
marcozamperlinAuthor Commented:
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
IrogSintaCommented:
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
marcozamperlinAuthor Commented:
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
IrogSintaCommented:
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
marcozamperlinAuthor Commented:
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
IrogSintaCommented:
You need to follow the sample db I gave you.  Look at the OnFormat event of the detail section of the report.
0
marcozamperlinAuthor Commented:
Your sample that I have does not have a report but only a table and a form ...
0
IrogSintaCommented:
Oops, I thought I uploaded my revised demo in my second post.  Sorry about that.  Here it is:
SignatureInk.accdb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marcozamperlinAuthor Commented:
This version works well. Question: Is it really necessary to use a temporary file?
0
IrogSintaCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.