PROBLEM WITH Application.FollowHyperlink

Question

We have completely replaced the computer with a brand new computer and installed all from scratch. Application.FollowHyperlink worked for a few days, then the user went on vacation. When she returned on Aug. 15, windows and office updates auto installed, and the Application.FollowHyperlink stopped working again. No one else in the office (50 users) is having this problem. The current build on the offending computer is Version 2205, Build 15225.20394 Click-To-Run)

Here is the issue:

We have a FE.accdb on 50 computers that has this:

Public Function GoToFolder()

On error GoTo err_Process

Application.FollowHyperlink Forms.aa.MatID.Column(1)

Exit Function

err_Process:

msgbox "Unable to Go To Folder"

End Function

On ONE computer only, it has suddenly stopped working. No error message, no nothing. Just ignores the command entirely. When I step through it, the immediate window shows the correct folder name as Forms.aa.MatID.Column(1), and it then passes through that line with no error message, right to the Exit Function line, but explorer does not open at all.

The function is accessed by command buttons on forms, as well as AutoKeys macro mapped to Ctrl+O. None are working on this one computer.

Answer 1

For an alternative to a hyperlink you might like to take a look at BrowsDemo.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

This little demo file illustrates how to simulate a hyperlink with text in a control.  It calls the Windows API ShellExecute function.  While the demo is intended to show how to browse to and open or print a file, the same code will do perfectly well to open a Web page.

Answer 2

Insert that in your app Module

Then call it like example GoHyperlink Forms.aa.MatID.Column(1)

Maybe it will help!

Answer 3

Access Hyperlink SubAddress Bug? | DEVelopers HUT (devhut.net)

We have updated the offending machine to version 2206, build 15330.20264 because another machine in the office is successful with that build.

IT HAS NOT CORRECTED THE PROBLEM.

We have backed off the offending computer to version 2204.

IT HAS NOT CORRECTED THE PROBLEM.

After both updates/predates, we ran full MSOffice repair and restarted the machine.

IT HAS NOT CORRECTED THE PROBLEM.

P L E A S E H E L P :-)

Answer 4

Access Hyperlink SubAddress Bug? | DEVelopers HUT (devhut.net)

These threads indicate that 2205 was resolved as of May. And the offending machine is 2205. But I tried it on a machine with 2206 and the issue is resolved, so I will try updating to that.

Answer 5

Access Hyperlink SubAddress Bug? | DEVelopers HUT (devhut.net)