Hyperlink unable to open

[Guest]

I'm using Access2002 & have hyperlinks in my customer data base to MS Streets
& Trips 2004. This program uses a .est extention. A couple of days ago I
begain receiving error message "Hyperlink unable to open. No program is
registered to open this file." I can no long open any hyperlinks to Street &
Trips; but other hyperlinks on this same Access data base, in question, still
opens links to other Access and Excel files. I've tried deleting and
reestablishing hyperlinks to Street & Trips; but noting seem to rectify this
issue. PLEASE HELP.

 

[Arvin Meyer [MVP]]

This is really a Windows question, not an Access one, but I'll take a stab
at it. Open up the Windows Explorer (My Computer) and click on Tools ...
Folder Options ... File Types tab

Look for the est extention and make sure it is set to OPEN Streets and
Trips.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks, Arvin. I'm almost there. I've included MS Street & Trips 2004 to file
types tab. Now when I try to open the hyperlink Street & Trips begin to open
but the following message appears: "The file does not exist in the specific
location". I've tried deleting and reestablish the link. But I continue to
receive the same error message. Please advise.
--
Thanks,

BobJL

This is really a Windows question, not an Access one, but I'll take a stab
at it. Open up the Windows Explorer (My Computer) and click on Tools ...
Folder Options ... File Types tab

Look for the est extention and make sure it is set to OPEN Streets and
Trips.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer]

I'm guessing that it is remembering where the file was, or is using a
default. Right-click on the hyperlink and choose "Edit". Is the hyperlink
right?

You can also use a regular text field and code to send it as a hyperlink:

Private Sub txtBoxName_DblClick(Cancel As Integer)
Application.FollowHyperlink Me.txtBoxName
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

Thanks, Arvin. I'm almost there. I've included MS Street & Trips 2004 to file
types tab. Now when I try to open the hyperlink Street & Trips begin to open
but the following message appears: "The file does not exist in the specific
location". I've tried deleting and reestablish the link. But I continue to
receive the same error message. Please advise.
--
Thanks,

BobJL

 

[Guest]

Alvin, I'm a novice when it comes to adding text & code. I tried to decipher
what you suggested but it's Greek to me. If you could make the text field &
code in simple terms, I would greatly appreciate it.

The path to the hyperlink is C:\BJL\Maps\Data\FileName.est (Only
"...\Maps\Data\FileName.est" is displayed in applicable cell). I've
re-checked Access data base table in design view: Data Type is hyperlink.
I've deleted (10) current links and have re-inserted applicable hyperlink
from Access to MS Street & Trips. But each and every time I try to open the
links, I receive the same error message that the file does not exist. I have
approx (300) of these hyperlinks that opened OK just a few days ago; but now
zippo. Do you think if I were to re-install Street & Trips over the existing
program, the problem will fix itself or would I only be asking for additional
problems?

--
Thanks,

BobJL

 

[Arvin Meyer [MVP]]

OK, I'll try to explain it better.

1. Make a copy of your database as a backup
2. Change the datatype in your table from hyperlink to text
3. On your form, make sure the textbox is still bound to the field in the
underlying table.
4. In Design View, click on the text box and open a property sheet.
5. On the Event tab of the property sheet, locate the double-click event and
click inside that event's box.
6. It becomes a combo box ... drop the arrow down and choose [Event
Procedure]
7. You will see an ellipses ( ... ) to the right of the box for event
procedure, click on it and a code window will open.
8. In the code window, you will see:

Private Sub txtBoxName_DblClick(Cancel As Integer)

End Sub

with the name of the textbox instead of: txtBoxName

9. Add the following line:

Application.FollowHyperlink Me.txtBoxName

substituting your own textbox's name for: txtBoxName

10. Save your work.

Now back in form view find a record with the path and file name filled in,
or add one.

Double-click on that textbox and your file will open.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access