Photos from a scanner

[Mike Busch]

Is there anyway to scan a photo and have it go directly
into the photo field as a new entry on a form in access.
Thanks in advance

 

[Adrian Jansen]

Only if your scanner software can be automated to run as an OLE provider
under Access. Some TWAIN compliant scanners will do this, but I have never
done it.

You can however save your scans for this application always to one folder,
then use relatively simple code in Access to read that folder, and add any
new file names to a table. You can put this code in the Load event for the
form, then the read for new files happens automatically. Then your form can
pick up the entries from there.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control