Launching paint using got focus

[martlewis]

Hi

I'm using a database in access 2007 that has a field which is an embedded bitmap image. At the bottom of the main form is a signature field which on getting focus runs the event procedure...

Sub Signature_GotFocus()
DoCmd.RunCommand acCmdInsertObject
End Sub

I then have to select the type of file to insert. by choosing bitmap image mspaint is launched and my customer can sign the form using a stylus.

What I want to do is have mspaint launch automatically when the field gets focus and open with a specific canvas size ready for a signature. Is this possible?

edit: If there's a better way to capture a signature field using touch screen inpout without having to resort to leaving access and using paint I'd rather do it that way tho.

many thanks.

 

[the_net_2.0]

why dont you just upload a signature of people?? or multiple signatures?? put them in a directory, and reference them when needed. or better yet, past them into a field, an image control, or something else. They DO print too. I used to do that with a check writing program all the time. I stored the signature and wrote checks simply by printing them out in access with an image as my signature.

 

[martlewis]

I'm capturing the signature from customers on-site. I create the invoice for work completed and customer signs the job off. Don't think the uploading of signatures will work.

I want the signature embedded, and using an ole object this works... I just want to automate the process. Instead of having to select the type of object I want, I'd rather that paint opened as soon as the ole object field gets focus... if that makes sense?

 

[martlewis]

Solved.

Used a workaround of copying in an image from a default first record.