Using digital pen to write a signature in a form's picbox or something , any ideas?

Expert Im trying to use my digital pen to write signatures on a preloaded image in my Form and save to file.
The pen should write similar to ms paint or something and the i click a command to save to file
Please help me on the way to do this?
(NOTE: the pen works just like the mouse when writing with better control thats all)
Sam CohenConsultant to Digital/DeveloperAsked:
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.

you just need to add an OLE-field to your datatable

do a form, which displays the OLE-field (for an example look at http://www.itesgemeiner,com/service/EE/oletestform.mdb )

open ms-notepad, do some drawing, cut
then you have it in the clippboard
set focus on olefield in form, > paste
so the OLE-field will take it, as long it is an OLE compatible document and it will renmember the application, so if you doubleclick it later it will automatically open this app.

potential problem in multiuser environment: if you put in an OLE from an app, your colleage has not installed he will not see it or be able to change it

regards, Franz
sorry misstyped the link

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.

Sam CohenConsultant to Digital/DeveloperAuthor Commented:
Well Bonjour
I want to be able to write in  the form's image
like the ms paint  no fancy brushes needed or size
just beable to write in black on an loaded image  
 Look here:

That link is similar to want i want
in Access VBA you cannot draw like in VB, so above example is not to be translated to VBA.
only thing you can do:
make an empty *.bmp assign it to all new records
to write, you will need to doubleclick it. then the app for *.BMP will opren
write the signature
close the app
signature is in OLE field in access Form

regards, Franz
Sam CohenConsultant to Digital/DeveloperAuthor Commented:
Sure you can do it in VBA

how do i edit  the code in download file above to make the pixel smaller and the writing smoother and to save to file (jpg)?
i looked at the example
for a signature it is too rough
it does not store the picture anywhere, it is just display
to store a signature to a record, you will need the described OLE-method

regards, Franz
Jeff TennessenAssistant Vice PresidentCommented:

Stephen Lebans, whose PaintProgram you referenced above, has an image class that basically recreates the functionality of a VB PictureBox control in Access, using a subclassed Image control. It should give you what you need. You can find source code at in both Access 97 and Access 2000 versions.


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
Sam CohenConsultant to Digital/DeveloperAuthor Commented:
Wow , how did i miss that!!
Sam CohenConsultant to Digital/DeveloperAuthor Commented:
I think im going to redesign Stephen Leban's website for free!
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.