To start scanning from Access

[ThordP]

ThordP (TechnicalUser)
To open scanned documents it is possible to calculate the actual file name via Access and then
use Hyperlink to display the image(s).
Is it possible to use the same method or something similar when I want to scan a dokument and use the calculated file name when I want to save the document?
Of course I can calculate the file name via Access, store it in a field in the form and then let the user copy and paste it in the Save as field in the Image program, for instance the program that is available in Windows, but then it will always be a risk that the user makes a mistake.
Earlier in another project I was using an image software where I could do this by using DDE.
The actual software (Pixedit) is however quite expensive and perhaps it is possible to carry out the same by using a software that is free....
Just to let the user press a button in the Access form that will start the scanning program and automatically save the document using the correct file name, calculated via the Access routine..
I would be very happy if someone knows anything about this problem!

Thord

 

[MinusM]

I am using Kodak controls which used to come with Windows until Win2K. It is not available with XP but you can search them on the net.
The site below is one of the places where you get them

http://8mm2avi.netfirms.com/Install.htm

If you know where the scanning control is saving images and in what name, using access you can move the file to a new folder under a new name generated by the access program. Then user will not be involved in the saving business.
You will have to use Ontimer event to see if any new file has been scanned in the default directory and move them

Best of luck

 

[rlf1957]

MinusM - Could you expand on how to use the Kodak Controls in a command Button, to activate an ADF Scanner.
I have build a simple DB to allow searchability but I am really just an amateur with Access. I have looked at a button to do this in a product sample of DBPix. They use their own ActiveX controls though and they are not free.

I have installed the KODAK Image Controls and registered them within Access 97.

Any further guidance you could pass along would be appreciated.