How to Display Scanned Images With Associated Application

[charles.kendricks]

I have presented this problem recently, but was not as specific as I
should have been. I have a patient database with a patient information
form. I also have a large folder of patient records which have been
scanned to disk. The scanning software names each scanned image in the
following format: firstname_lastname_imagexxx, where xxx is a unique
autoincrementing number, so that each and every scanned file has a
unique xxx number. Also each patient might have anywhere between 2 to
10 scanned images

I am still a raw novice at VBA programming, but I need to be able to
display the scanned images from the patient information form. I want
to display the scanned images with the associated application which is
Windows Picture and Fax Viewer. I am willing to entertain any and all
ideas as to the best method I should use to accomplish this task.

Thanks in Advance

 

[Arvin Meyer [MVP]]

I'd use ShellExecute to start the app:

http://www.mvps.org/access/api/api0018.htm

It looks complex, but it really isn't. Just put the code from the Web page
in a standard module and call it like it shows in the comments.

 

[charles.kendricks]

Thanks, but wouldn't the user need to know the exact file name of the
scanned image? In my case all the user would know would the the first
and last name of the patient. I know how to get that information from
the patient form, but what about the rest of the file name,
particularly the unique incrementing number portion of the scanned file
name?

 

[Arvin Meyer [MVP]]

You need to have a list of all the files for that patient, probably
displayed in a subform, then clicking on the record would open the form to
that record. While the following app downloads the paths to Word.doc and txt
fiels to a table, it could be modified to do your image files:

http://www.datastrat.com/Download/DocMgr_2K.zip