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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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] wrote:
> 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.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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
> >

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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] wrote:
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>> <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >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
>> >
>