H
hubbiida via AccessMonster.com
I have read repeatedly on this forum about using "Application.
Followhyperlink" to launch files in their default applications. I am trying
to use this techique to open .jpg files, using a control from a form to
provide the file path. The problem is that the .jpg files open in Internet
Explorer. I have associated .jpg with a graphics program (Fireworks) and when
a file is double clicked in Windows Explorer it opens in that application,
but I cannot get them to open in Fireworks from Access using Application.
Followhyperlink...
I have also tried the following code (which I found on anther post):
Dim app_name As String
app_name = "C:\Program Files\Macromedia\Fireworks MX 2004\Fireworks.exe
<path_to_file>"
Call Shell(app_name, 1)
This works great when I put in a literal path to the file, but when I simply
name the control (which contains the path) I get different errors depending
on the syntax I use.
Any suggestions for the proper syntax to use a control as <path_to_file>
above, or on why the .JPG files always open in IE would be most welcome.
Followhyperlink" to launch files in their default applications. I am trying
to use this techique to open .jpg files, using a control from a form to
provide the file path. The problem is that the .jpg files open in Internet
Explorer. I have associated .jpg with a graphics program (Fireworks) and when
a file is double clicked in Windows Explorer it opens in that application,
but I cannot get them to open in Fireworks from Access using Application.
Followhyperlink...
I have also tried the following code (which I found on anther post):
Dim app_name As String
app_name = "C:\Program Files\Macromedia\Fireworks MX 2004\Fireworks.exe
<path_to_file>"
Call Shell(app_name, 1)
This works great when I put in a literal path to the file, but when I simply
name the control (which contains the path) I get different errors depending
on the syntax I use.
Any suggestions for the proper syntax to use a control as <path_to_file>
above, or on why the .JPG files always open in IE would be most welcome.