A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Controlling which app opens a hyperlink image file?



 
 
Thread Tools Display Modes
  #1  
Old July 7th, 2009, 05:22 PM posted to microsoft.public.access
SharoneM
external usenet poster
 
Posts: 2
Default Controlling which app opens a hyperlink image file?

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!
  #2  
Old July 7th, 2009, 06:58 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Controlling which app opens a hyperlink image file?

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

"SharoneM" wrote:

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!

  #3  
Old July 7th, 2009, 08:16 PM posted to microsoft.public.access
Damon Heron[_3_]
external usenet poster
 
Posts: 257
Default Controlling which app opens a hyperlink image file?

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_Fullscre en " 'all on one line!
strPath = WPFV & strPath
retv = Shell(strPath, vbNormalFocus)

End Sub


Damon

"SharoneM" wrote in message
...
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!



  #4  
Old July 8th, 2009, 05:02 PM posted to microsoft.public.access
SharoneM
external usenet poster
 
Posts: 2
Default Controlling which app opens a hyperlink image file?

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

"SharoneM" wrote:

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!

  #5  
Old July 8th, 2009, 06:07 PM posted to microsoft.public.access
Damon Heron[_3_]
external usenet poster
 
Posts: 257
Default Controlling which app opens a hyperlink image file?

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


"SharoneM" wrote in message
...
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

"SharoneM" wrote:

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!



  #6  
Old July 8th, 2009, 06:08 PM posted to microsoft.public.access
Fred
external usenet poster
 
Posts: 1,451
Default Controlling which app opens a hyperlink image file?

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

  #7  
Old July 8th, 2009, 07:13 PM posted to microsoft.public.access
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Controlling which app opens a hyperlink image file?

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.co...lynx-baby.jpg#

You will end up in your browser.

Clifford Bass

"SharoneM" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:35 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.