Question about VBA and images

[frustrating]

I was wondering, and I'm not sure if this can be done, but it's worth asking...

Is it possible to use VBA to "Map" pieces of an image based off the user's mouse dragging selections. So the user would open the tif, drag/selection pieces of the certificate he/ she wants (each selection can be a different color or labeled), and then take the information inside and then write some parsing code for an sql insert.

For example: I'd like to be able to get information from an insurance certificate in tif format (it's already OCR'd) and then highlight pieces of information I want on the image and put them into their respective fields in Access, since parsing smaller bits of text selection is 100000x more accurate than a huge file, which is what I started doing and realized it wouldn't work.

Can this be done?

 

[John Big Booty]

Perhaps the sample here is doing the sort of thing you are after, if not have a look at some of ChrisO's other drag and drop samples.

 

[frustrating]

Thanks for the tip. I'll look into this a bit more. His work is done on what seems is a grid, I'm not sure if it can be replicated with tiff files.

 

[jdraw]

You might also try searching for examples of Access vba interacting with IrfanView. I have seen an access database where the creator could move parts of pictures, resize, rotate etc.

I found this link (not sure if this is the same one)
http://www.access-programmers.co.uk/forums/showthread.php?t=187024

 

[frustrating]

You might also try searching for examples of Access vba interacting with IrfanView. I have seen an access database where the creator could move parts of pictures, resize, rotate etc.

I found this link (not sure if this is the same one)
http://www.access-programmers.co.uk/forums/showthread.php?t=187024

Interesting. This may be more what I need.
I'll look into this a bit.