Start Scanner From Within Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have lots of customer records in MS Word which I reach from my access
database quite successfully. Each job record has a unique number which I use
to generate a filename in MS Word. I would like to scan each maintenance
report I get from service jobs done. I want to start/control the scanner
directly from within the database i.e. the operator would bring up the job in
the database, start the scanner and the filename (from the job number) would
be automatically created/added to the image from within the database. Can
anyone help please?
 
You will need some software to drive the scanner. probably an OCX
somewhere. Once you've got that then you will just be dealing with the
resulting Tiff file. (from the scanner, tiff's can be multipage too, if
thats any help.) The OCX will have the ability to display the tiff as well
so its all tidy. Have a search for OCX scanner etc
The database will bloat if you put the tiff's in the database. Or any
images or files such as word documents for that matter.
You would be well advised to store the file on disk and only keep a
path/file reference to it in the database. Use code/OLEObject/OCX controls
to display them.

hope thats a start. I used to do this type of work ages ago but can't
remember much off hand just now. But once you've got a suitable OCX then
its really easy.
PS: you might have to buy one, but I doubt it...
The easist thing to use is Windows Imaging, it's free or the professional
version is really cheap. Depending on what operating system you are using
will determine what version you need. If the PC is Windows NT, that version
can scan but Windows 95/98 versions can't......I think this is right...
 
Muchas Gracias. I'll give it a go.

SJ said:
You will need some software to drive the scanner. probably an OCX
somewhere. Once you've got that then you will just be dealing with the
resulting Tiff file. (from the scanner, tiff's can be multipage too, if
thats any help.) The OCX will have the ability to display the tiff as well
so its all tidy. Have a search for OCX scanner etc
The database will bloat if you put the tiff's in the database. Or any
images or files such as word documents for that matter.
You would be well advised to store the file on disk and only keep a
path/file reference to it in the database. Use code/OLEObject/OCX controls
to display them.

hope thats a start. I used to do this type of work ages ago but can't
remember much off hand just now. But once you've got a suitable OCX then
its really easy.
PS: you might have to buy one, but I doubt it...
The easist thing to use is Windows Imaging, it's free or the professional
version is really cheap. Depending on what operating system you are using
will determine what version you need. If the PC is Windows NT, that version
can scan but Windows 95/98 versions can't......I think this is right...
Click to expand...
 
Back
Top