Creating Hyperlinks to Field data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that only shows a list of Employee's names. How can I add a
hyperlink so a user can click on the person's name and link to that
employee's profile document in Intranet?

I have read many posts here and have tried to do this with a label or a text
box in a form or a report and can not get any links to work. I need a more
explanatory answer as I don't understand exactly how to do this.

How can a get the label to dynamically be the path and the employee's name?

[AgentName] is the data field in the Query.

Another thought I had was to create an update query that would add the
address to another field in the table. But I still don't understand how I
would make the field that would now contain the actual hyperlink address and
actual link.

Can someone please help me?

It seems so simple!
 
Add a hyperlink field to the table, or just a text field and use code
similar to that below to follow the hyperlink:

Private Sub cmdHyperlink_Click()
Dim strPath As String
If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Me.cmdHyperlink.HyperlinkAddress = strPath
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top