[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

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)
0
Sam Cohen
Asked:
Sam Cohen
  • 5
  • 4
1 Solution
 
bonjour-autCommented:
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
0
 
bonjour-autCommented:
sorry misstyped the link

ttp://www.itsgemeiner.com/service/EE/oletestform.mdb
0
 
bonjour-autCommented:
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
Sam CohenAuthor 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:http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20856733.html?query=digital+pen&topics=93

That link is similar to want i want
0
 
bonjour-autCommented:
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
0
 
Sam CohenAuthor Commented:
Sure you can do it in VBA
here:
http://www.lebans.com/DownloadFiles/PaintProgramVer2.zip

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)?
0
 
bonjour-autCommented:
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
0
 
Jeff TennessenAssistant Vice PresidentCommented:
all4artz,

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 http://www.lebans.com/imageclass.htm in both Access 97 and Access 2000 versions.

Jeff
0
 
Sam CohenAuthor Commented:
Wow , how did i miss that!!
Thanks
0
 
Sam CohenAuthor Commented:
I think im going to redesign Stephen Leban's website for free!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now