asked on

MIcrosoft access - form signature box

trying to insert signature box in microsoft access form. this will help me take customer signatures once task is complete.
code was purchased online - but cant integrate this functioaanlity in microsoft access db.
on "accept button" it gives me error code " Compile error User-defined type not defined" highlights the code line
"Dim objInk AS MSINKAUTLib.InkPicture"
let me know if you require any more information that will help u help me.

thank you.

ASKER CERTIFIED SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

karta sounthe

ASKER

this is what i have done

Table
Name : tblInkEdit
Field Data Type
ID : Autonumber
InkData : OLE Object
Form
Name : frmInkPicture
Data Source : tblInkEdit
Control : Microsoft InkPicture Control
Name : ActiveXCtl1
Control : Text Box
Name : txtID
Source : ID
Control : Command Button
Name : Command3
Caption : Save

CODE
Private Sub Command3_Click()
Me.InkData = Me.ActiveXCtl1.Ink.Save(IPF_GIF, IPCM_NoCompression)
End Sub
Control : Command Button
Name : Command6
Caption : Load

CODE
Private Sub Command6_Click()
Dim v As Variant
Dim b() As Byte
Set v = Me.ActiveXCtl1
b = Me.InkData.Value
v.Ink.Load b (i get a error here)
Set v = Nothing
End Sub
Database4.accdb
error.png

SOLUTION

Shaun Vermaak

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

karta sounthe

ASKER

any idea what i'm doing wrong?
i copied the contents to a new access and it dispalys me the following error message
"there was error loading an activex control on one for the form or reports"

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Joe Howard

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Split:
-- Jim Dettman (Microsoft MVP/ EE MVE) (https:#a42123659)
-- Shaun Vermaak (https:#a42123898)
-- Jim Dettman (Microsoft MVP/ EE MVE) (https:#a42125018)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer