Best Way to Scan

D

Dan Sweetwood

I need to scan faxed lab reports into a patient database. I considered using
a hyperlink to a folder for each patient but I am struggling with how to get
the hyperlink to link directly to the patient folder without having to put in
the name each time. The other option is to directly scan in as an object by
name (or patient ID number) but I am concerned as to how large the database
will become. Any suggestions? I really appreciate your help!
 
M

Mike Painter

Dan said:
I need to scan faxed lab reports into a patient database. I
considered using a hyperlink to a folder for each patient but I am
struggling with how to get the hyperlink to link directly to the
patient folder without having to put in the name each time. The other
option is to directly scan in as an object by name (or patient ID
number) but I am concerned as to how large the database will become.
Any suggestions? I really appreciate your help!

You can use the Dir() command to pick the names of the files and place the
file name in a new record after checking for duplicates.
If there is some naming convention in the file names relating them to the
patient should not be difficult.

With photos I put the file name in the field that will use it and again in a
description or name field, then I can just move through the records and fill
in the names etc.
 
Top