Question Scanning Directly from a button in Access 2010

[davecousins]

Hi,
Is there a way to directly access a TWAIN compatible scanner directly from a form button in Access 2007/2010 so that it will add one or more images to the specific table?

 

[davecousins]

Anyone ever accomplished this?

 

[Old Man Devin]

Can't say I've heard it done, but to do it you would need to do it in two steps:

1) Hard bit. Write a VBA macro that can use the scanner to get an image. The macro would then add the image to the table just like adding regular data to a table, (probably need an 'attachment' type field to receive it.
2) Easy bit. Make a custom button for your Ribbon that runs that macro. Done via the customization menus for the Ribbon in Access.

Whether VBA can control the scanner at all is unknown to me, and will likely depend on the specifics of the device. Try looking around on the wider internet for info if you haven't already. Otherwise, I suspect this will be a challenging code job, although it's definitely possible, because everything is possible with coding in the end! (Just often so difficult that it takes years!).