Link A Scanned Insurance Application to Record In a Form In Access

[arnold]

I am trying to link a folder of scanned insurance applications that
use SS #'s as file names. I would like for the form to automatically
link the person that is currently showing in the form to their
insurance app in the separate folder if an app is available for that
person. Is there a way to link these without setting up a separate
hyperlink for each file? I would like as apps are scanned in to
automatically link with the person's SS # in the form. Any help would
be greatly appreciated!

 

[Paul Shapiro]

If you have too many files in a single folder Windows becomes extremely slow
performing directory listings and retrievals. I don't know how many is too
many, but there's no problem with 100 files and there is with 10,000. So if
you expect large numbers you might want to put them into subfolders, maybe
organized by the first x-digits of the SSN.

If you want this link to appear on a Person form, then in the OnCurrent
event of that form you can do a directory search for that person's file. If
the file exists, you enable a command button or hyperlink to open the file.
You don't have to store anything in the db to make this work. If your
scanning application can update the db, you might choose to store the
filename and/or path in the db. You could also have your code update a field
in the db if it finds a file.
Paul Shapiro