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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|