Access 2007 Hyperlink not working (1 Viewer)

A

Avick

Registered User.

Local time

Today, 08:38

Joined

Mar 11, 2000

Messages

49

• Jul 3, 2007

• #1

Hi Chaps
I am having a problem with Access 2007.

I have a hyperlink field that should take me to a web page related to the specific record I am in at the time.

The problem is, they hyperlink won't work.
As I move over the link the pointer changes to a finger as expected but when I click the link nothing happens.

I then copy and paste the link into a browser window and it works perfect, displaying the web page as expected so I know its not a problem with the hyper link its self

I have the IsHyperlink set to YES

I'm at a complete loss as to why its not working as expected.

 

ted.martin

Registered User.

Local time

Today, 07:38

Joined

Sep 24, 2004

Messages

743

• Jul 3, 2007

• #2

What is the exact hyperlink? There may be a character in it that Access doesn't like. Paste it here - precisely.

 

A

Avick

Registered User.

Local time

Today, 08:38

Joined

Mar 11, 2000

Messages

49

• Jul 4, 2007

• #3

The link is as follows:
http://www.newebirl.eu/invoices/invoices.aspx?access_key=kp9u87sr1

Nothing happens if you try to open this link from access.

Another link is:
http://www.newebirl.eu/invoices/1816.pdf

This should open copy of the invoice for clients to print but again, nothing happens.

(the links and references have been changed to protect customer data but they should take you to the relevant page)

 

C

CEH

Curtis

Local time

Today, 02:38

Joined

Oct 22, 2004

Messages

1,187

• Jul 5, 2007

• #4

I believe you need to breakup your site address.......
In "hyperlink Address" put http://www.newebirl.eu/ and in "hyperlink sub address" invoices/invo..._key=kp9u87sr1

 

boblarson

Smeghead

Local time

Today, 00:38

Joined

Jan 12, 2001

Messages

32,059

• Jul 5, 2007

• #5

Actually, I believe that IsHyperlink only gives you the hand. You have to set the click event to:

FollowHyperlink Me.YourTextBoxName

 

A

Avick

Registered User.

Local time

Today, 08:38

Joined

Mar 11, 2000

Messages

49

• Jul 5, 2007

• #6

Thanks Bob
That did the trick.
Is there a way to set the browser where the link opens.
By default it opens in IE and I use Netscape 9 as my default browser.

If not then thats not a problem. I'm just happy it works

Alan

 

boblarson

Smeghead

Local time

Today, 00:38

Joined

Jan 12, 2001

Messages

32,059

• Jul 5, 2007

• #7

Avick said:

Is there a way to set the browser where the link opens.
By default it opens in IE and I use Netscape 9 as my default browser.

Click to expand...

There may be, but I'm not sure of the code to do so. You might google it if you want to work on that one. The SHELL command may work for you, but I am not sure.

 

C

CEH

Curtis

Local time

Today, 02:38

Joined

Oct 22, 2004

Messages

1,187

• Jul 5, 2007

• #8

You might also want to look at this on hyperlinks in 2007
http://msdn2.microsoft.com/en-us/library/bb225080.aspx
In 2007 doesnt look like an onclick event is required.

 

J

John Thompson

New member

Local time

Today, 08:38

Joined

Dec 22, 2011

Messages

1

• Dec 22, 2011

• #9

Thank you to Bob Larson ... This one was annoying me, since the MS Access "follow if hyperlink" works fine most of the time.

This has resolved the issue for me!

 

U

US2U

New member

Local time

Today, 03:38

Joined

Feb 4, 2012

Messages

1

• Feb 5, 2012

• #10

I'm not successful with this fix, but the problem is likely mine.

I'm trying to add FollowHyperlink Me.MyTextBoxName to the ON CLICK event (property) of my form. But get a message saying object FollowHyperlink Me cannot be found. If I remove FollowHyperlink Me, I get the same message about MyTextBoxName (the real name), which has no spaces or non-alpha characters.

Additional Info: My record-level hyperlink string, which works fine outside of Access, is unique to each record in my underlying table. I used an UPDATE query to insert this unique hyperlink string into the table's (previously defined) hyperlink field by concatenating the URL portion(s) of the string with the unique data for the record (stored elsewhere on the record).

All thoughts, suggestions, and corrections are welcomed...

 

E

EmilyTheChef

New member

Local time

Today, 01:38

Joined

Mar 8, 2012

Messages

3

• Apr 18, 2012

• #11

Re: Access 2007 Hyperlink not working (Add "#" (no quotes) before and after text)

Solution that worked for me: format the hyperlink text with a leading and trailing "#" (no quotes) #\\drive\folder\filename.pdf#

I had a similar issue. I wanted a hyperlink for users to click that will open a file on a network drive. I had to do some data manipulation in Excel, where I created (what I thought was the correct) formatting for the hyperlink address.

But when I copied and pasted into the Hyperlink field in my Access table, it seemed to put a leading space at the end of the text (I tried Trim functions, didn't work), and when I pressed F2 then delete, I saw a "#" at each end of the text in my field. So in Excel, I purposely formatted the hyperlink text with a leading and trailing "#" (no quotes) #\\drive\folder\filename.pdf# and when I pasted THAT from Excel into the Access hyperlink field, it worked!

I'm SO grateful to these forums for being instrumental in helping me create my first "for an end user" database. I'm tickled that I can finally provide an answer for someone else...