Using a HyperLink Stored in a Field

[Maillme]

Hi there,

I have a field "link" which contains a full hyper link address.

beside this field, I have a button.

I want to be able to click this button, and it loads the web page (associated with the hyperlink) in a new window.

I've been looking at follow hyperlink method - but it has just confused me more.

many thanks for any help,
Neil

 

[ProgramError]

Just clicking on the hyperlink should do the same thing. No need for a button.

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Maillme]

Hi ian,

thanks for the reply.

Unfortunately, when i click into it - it behaves like any other text field. E.g. - I can type some text.

Neil

 

[ProgramError]

The field in the table needs to be a hyperlink. You may have it set to text or memo.

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[Maillme]

aha,

Im with you - that wont work in my case,as im also want to perform some other actions when the user clicks the button (copy some text to the clipboard).

Also, the field is not from the table, its an additional one i've added that works out a few things using the data from the table, to get the final hyperlink / web address.

so, in my case - i think i really need a button.

Anyone?

thanks again for your help,
neil

 

[Maillme]

Sorted:

Private Sub Command65_Click()
Dim strhyperlink As String

// Copy a field's value to the clipboard
Me.cat_no.SetFocus
DoCmd.RunCommand acCmdCopy

// open the link
strhyperlink = Me.discogs_link
Application.FollowHyperlink strhyperlink, , True, True
End Sub

 

[ProgramError]

well done

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.