Controlling which app opens a hyperlink image file?

[SharoneM]

I have a designated folder which stores my jpeg image files to be hyperlinked
to an Access 2007 database table. When I click on the images in that folder,
they are set to open using the "Windows Picture and Fax Viewer" app by
default. However, when I click on the hyperlinked jpeg image within Access,
they open using the app "Windows Internet Explorer" (IE). I don't know where
I can change the app which opens the images within Access. I'd like for them
to open using the app of my choice (in this case, the Windows Picture and Fax
Viewer). All of this is on my local desktop PC (no servers or admin
personnel other than myself involved in settings). The OS is Microsoft
Windows XP.
Much Thanks!

 

[Clifford Bass]

Hi Sharone,

You could try this, which may or may not help: Open up your "My
Computer" icon. Go to the Tools menu, then the Folder Options item and then
the File Types tab. Locate the .JPEG extension and click on it. In the
lower part click on the Change button and choose the desired program for
opening that type of file. Repeat for the .JPG extension. Note that IE may
want to reset these the next time you start it.

If that does not help, you could look into the FTYPE and ASSOC commands
documented at <http://www.computerhope.com/overview.htm>.

Clifford Bass

 

[Damon Heron]

This will work. You have to construct your string to add the path to the
selected file.
This is a command button click event--

Private Sub Command32_Click()
Dim retv
Dim WPFV As String
Dim strPath As String
strPath = "C:\number.bmp" ' path to your picture
WPFV = "C:\Windows\system32\rundll32.exe
c:\windows\system32\shimgvw.dll,ImageView_Fullscreen " 'all on one line!
strPath = WPFV & strPath
retv = Shell(strPath, vbNormalFocus)

End Sub


Damon

 

[SharoneM]

Thanks to both of you for so quickly responding to my query!

Clifford: I did try the Folder Options route, but within Access 2007 IE
insists on opening my hyperlinked images! Very annoying. I'll definitely
check out the FTYPE and ASSOC cmds, though.

Damon:
Where and how do I insert your code to implement? (I'm fairly adept at
basic computer use, but somewhat clueless when it comes to code).

Thanks!
SharoneM

 

[Damon Heron]

You have the image name and path stored in a table? Create a form that has
a textbox (not a hyperlink) with the record source of the form = to the
table, and the control source of the textbox= to the field in the table that
holds the path and name. Lets call the textbox txtPath. Add a command
button to the form, and in the click event, add my code, but where it says:
strPath = "C:\number.bmp",
change it to: strPath= me.txtPath

This code is in the vbeditor window - you know how to get there, correct? If
not, in design mode of the form, rightclick on the form and/or any controls,
and you select Properties, with 5 tabs on the Property sheet. The source
field is on the data tab. The On click event is on the Event tab, and you
click the (...) on the far right of that field to get to the vb window where
the click event code can be entered. Compile and save from the VB Edit
window.

Now, when you click on the button, the code will run for the current record
showing on the form and show your image using the WinPicFax Viewer.

Damon

 

[Fred]

One idea which may or may not be useful - you could do an end run around the
problem by storing the path and file name is a text field and using code to
display the pictures on forms and reports

 

[Clifford Bass]

Hi Sharone,

You are welcome.

Yes, it is very annoying. However, when I click on a .jpg file link
stored in a hyperlink filed and it does open in the designated program--not
IE. Now, my files are out on a mapped network drive and the contents of the
hyperlink may look like this:

S:\potter.jpg#S:\potter.jpg#

If you are linking out to images on a web or FTP server with http://...
or ftp://... it will use IE or whatever you have defined as your default
browser / FTP client. So if your link looks like this:

#http://animals.nationalgeographic.c...StaticFiles/animals/images/800/lynx-baby.jpg#

You will end up in your browser.

Clifford Bass