Scanning From Access

[Ian King]

We have a database that records items of equipment.

As a new record is entered, a folder is created to store scanned images of
the calibration certificates for that item.

What would be really nice is to have a button on the form that would
activate the scanner and save the resulting image directly to the folder
created.

If anyone can point me to a solution for this, I would be extremenly
grateful.


Many thanks

Ian King

 

[Tony Toews]

We have a database that records items of equipment.

As a new record is entered, a folder is created to store scanned images of
the calibration certificates for that item.

What would be really nice is to have a button on the form that would
activate the scanner and save the resulting image directly to the folder
created.

The name for this standard is TWAIN. (Which stands for Technology
Without An Interesting Name.) I'd start with that acronym and Visual
Basic as your search keywords.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Arvin Meyer [MVP]]

You can do it with an ActiveX control which works in Access. Kodak used to
have one that worked in Access 97 and Access 2000 and came with the Windows
OS or perhaps with Office, I forget which. That is no longer available, so
you'll need to find another one. I just looked on Google and found:

http://www.gdpicture.com/gdpicture-...-activex.php?gclid=CIzqiZCQ_4kCFRn9gAodPlCsNQ

that purports to work from any 32 source that can call ActiveX controls, and
specifically names Access as one of them. I haven't tried it, but it looks
interesting, and the price is certainly reasonable ($95 for 1 developer and
a royalty-free distribution license)