Import scanned images

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am very new to access, but i am creating a database that
tracks various training and evaluations. The evaluation
form is filled out by hand and then scanned into the
system and stored. Is there anyway i can link the scanned
images to the corresponding employee's training session,
so when a report is run on an employee a list of
evaluations appears and can be viewed as the image?
 
Hi John

In case you don't want to import the scanned docs into the Access database, you could use a field with datatype 'Hyperlink' and enter the path and filename. Clicking on the link would open the appropriate programm for the file type

Or if you want to store the scanned doc in your database use instead fieldtype 'OLE Object' - but pay attention, this would raise the size of the database extremly depending on the size of the scanned doc

HT
Bernd
 
Thank you very much for the help,
If I wanted to just link to them using a Hyperlink, how
would i be able to dynamically assign the hyperlink with a
new path for each new entry? I would want to be able to
have a data field or a command button that would ask the
user where the file associated with the record is and then
assign it to the hyperlink. Thanks again
-----Original Message-----
Hi John,

In case you don't want to import the scanned docs into
Click to expand...
the Access database, you could use a field with
datatype 'Hyperlink' and enter the path and filename.
Clicking on the link would open the appropriate programm
for the file type.
Or if you want to store the scanned doc in your database
Click to expand...
use instead fieldtype 'OLE Object' - but pay attention,
this would raise the size of the database extremly
depending on the size of the scanned doc.
 
Hi John

I haven't used Hyperlink fileds myself yet. ;-

But if you have a table with a Hyperlink field you can insert the a hyperlink either by entering manually the whole path and filename or you can use from the menu Insert - Hyperlink and there you can browse through every drive on your PC, network, etc. This is working in a form as well

HT
Bernd
 
Back
Top