FollowHyperlink doesn't work in Access2010

[1DMF]

The FollowHyperlink function doesn't seem to work anymore in Access2010, how can I fix it.

I have a load of functions that use this method and ever since converting to Access2010 they don't work anymore?

Cheers,
1DMF.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[MajP]

you could build your own follow hyperlink using shell see here

http://www.access-programmers.co.uk/forums/showthread.php?t=204809

However, I have not heard anything about a bug in 2010. Do you get an error message.

 

[1DMF]

I don't get an error, nothing happens?

Before it would open IE and follow the dynamic URL that the VBA creates.

Now it doesn't do anything?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[missinglinq]

When code some doesn't run in 2007/2010, the first question has to be does any VBA code run? Code does not run in 2007/2010 unless your database resides in a folder that has been declared a “trusted” location.

To trust your folder, click:
Office Button (top left)
Access Options (bottom of dialog)
Trust Center (left)
Trust Center Settings (button)
Trusted Locations (left)
Add new location (button)

Here's a visual for it, courtesy of BTAB Development:

http://www.btabdevelopment.com/ts/default.aspx?PageId=13

If that doesn't do it, you might check to see if you have a Missing Reference to Windows Common Controls. I have seen a report of this causing this problem, when moving up from previous versions.

Linq ;0)>


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!