Directing Access to open a file...?

T

thebigpahoot

Hello,

My business has recently switched to DVD format, and I've undertaken a
project of indexing and archiving a bunch (~400) magneto-optical disks
that are packed with a plethora of information.

I've decided that re-uploading all information from these MO disks
onto the new DVD's is far too timely of a project. I'm going to rather
keep a dedicated PC with the proper drive to open these MO's and store
them away until the need arises. However, in order to pinpoint the
disk I need to find when a case pops up in my query, I'm going to
simply print a screen that contains all identifying information from
each case (Name,MRN,DateofProcedure, UniqueCaseID, etc.). This will
most likely be saved as a .jpg image, if I can have my way.

The easy part of what I want to do is creating an Access database to
archive the MO Disk number, side, and dates of procedures for each
Disk. The difficult part ( ..which I don't even know how viable this
is...), is to create a hyperlink when I query the Disk # that will
directly open Paint or Photoshop or PictureViewer to display the .jpg
from it's loaction on my hard drive.

(Or, consequently, I don't know if it's possible to upload images to
Access... this might take precidence over my earlier idea...)

Has anyone attempted this?

Thanks very much for your time!

Regards,

-KP
 
T

thebigpahoot

Hello,

My business has recently switched to DVD format, and I've undertaken a
project of indexing and archiving a bunch (~400) magneto-optical disks
that are packed with a plethora of information.

I've decided that re-uploading all information from these MO disks
onto the new DVD's is far too timely of a project. I'm going to rather
keep a dedicated PC with the proper drive to open these MO's and store
them away until the need arises. However, in order to pinpoint the
disk I need to find when a case pops up in my query, I'm going to
simply print a screen that contains all identifying information from
each case (Name,MRN,DateofProcedure, UniqueCaseID, etc.). This will
most likely be saved as a .jpg image, if I can have my way.

The easy part of what I want to do is creating an Access database to
archive the MO Disk number, side, and dates of procedures for each
Disk. The difficult part ( ..which I don't even know how viable this
is...), is to create a hyperlink when I query the Disk # that will
directly open Paint or Photoshop or PictureViewer to display the .jpg
from it's loaction on my hard drive.

(Or, consequently, I don't know if it's possible to upload images to
Access... this might take precidence over my earlier idea...)

Has anyone attempted this?

Thanks very much for your time!

Regards,

-KP
Click to expand...

Sorry! Answered my own question! It was exceedingly easy to figure
this out... just had to sit down and attempt it in Access.

Thanks for your... help? Yeah. Thanks.

-kP
 
I

i_takeuti

Hello,

My business has recently switched to DVD format, and I've undertaken a
project of indexing and archiving a bunch (~400) magneto-optical disks
that are packed with a plethora of information.

I've decided that re-uploading all information from these MO disks
onto the new DVD's is far too timely of a project. I'm going to rather
keep a dedicated PC with the proper drive to open these MO's and store
them away until the need arises. However, in order to pinpoint the
disk I need to find when a case pops up in my query, I'm going to
simply print a screen that contains all identifying information from
each case (Name,MRN,DateofProcedure, UniqueCaseID, etc.). This will
most likely be saved as a .jpg image, if I can have my way.

The easy part of what I want to do is creating an Access database to
archive the MO Disk number, side, and dates of procedures for each
Disk. The difficult part ( ..which I don't even know how viable this
is...), is to create a hyperlink when I query the Disk # that will
directly open Paint or Photoshop or PictureViewer to display the .jpg
from it's loaction on my hard drive.

(Or, consequently, I don't know if it's possible to upload images to
Access... this might take precidence over my earlier idea...)

Has anyone attempted this?

Thanks very much for your time!

Regards,

-KP
Click to expand...
 
M

Marco Pagliero

Hello,

My business has recently switched to DVD format, and I've undertaken a
project of indexing and archiving a bunch (~400) magneto-optical disks
that are packed with a plethora of information.

I've decided that re-uploading all information from these MO disks
onto the new DVD's is far too timely of a project. I'm going to rather
keep a dedicated PC with the proper drive to open these MO's and store
them away until the need arises. However, in order to pinpoint the
disk I need to find when a case pops up in my query, I'm going to
simply print a screen that contains all identifying information from
each case (Name,MRN,DateofProcedure, UniqueCaseID, etc.). This will
most likely be saved as a .jpg image, if I can have my way.

The easy part of what I want to do is creating an Access database to
archive the MO Disk number, side, and dates of procedures for each
Disk.
Click to expand...
I wonder how they find their MOs now.
The difficult part ( ..which I don't even know how viable this
is...), is to create a hyperlink when I query the Disk # that will
directly open Paint or Photoshop or PictureViewer to display the .jpg
from it's loaction on my hard drive.

(Or, consequently, I don't know if it's possible to upload images to
Access... this might take precidence over my earlier idea...)

Has anyone attempted this?
Click to expand...
I have a database of pictures related to some CD. I put a picture
control on my form and set the property 'picture' to the path of the
picture I want to show. The path I have stored in the same record as
the CD informations. So when they find the CD they want, the related
picture is shown (I let them press a button after they choose the CD,
because to show every picture while browsing takes much time).

Another time I didn't have a picture element on the form but I started
the viewer with the path of the picture. Something like that:
sub ShowButton_click()
shell "D:\elotiff.exe " & PathOfTheTiff, 3
end sub
'elotiff.exe' was the viewer, PathOfTheTiff ist the field on the form
where the path is stored (need not to be visible) and 3 means maximize
it.

These could be solutions for you, if I understand your question.

Greetings
Marco P
 
Top