Hyperlink Field

  • Thread starter Thread starter LisaB
  • Start date Start date
L

LisaB

You have the ability in Access tables to select "Hyperlink" as the field
datatype.

However, I have an Access 2000 front-end connected to a SQL 2000 back-end
and Hyperlink datatype is not an option

On my form, I would like a field to be used as a HyperLink field -- for
example fldResumeLink should hold the location where the resume can be found
on the network drive and when the user clicks on this field, the Resume will
open in a Word or Text file.

How can I accomplish this now???
 
LisaB said:
You have the ability in Access tables to select "Hyperlink" as the
field datatype.

However, I have an Access 2000 front-end connected to a SQL 2000
back-end and Hyperlink datatype is not an option

On my form, I would like a field to be used as a HyperLink field --
for example fldResumeLink should hold the location where the resume
can be found on the network drive and when the user clicks on this
field, the Resume will open in a Word or Text file.

How can I accomplish this now???
Click to expand...

You can store the path and file name in a simple text field. Then you
can use the Click or DblClick event of the text box bound to that field
to follow it as a hyperlink:

Private Sub txtResumeLink_DblClick(Cancel As Integer)

With Me!txtResumeLink
If Not IsNull(.Value) Then
Application.FollowHyperlink .Value
End If
End With

End Sub
 
Thank You very much

Dirk Goldgar said:
You can store the path and file name in a simple text field. Then you
can use the Click or DblClick event of the text box bound to that field
to follow it as a hyperlink:

Private Sub txtResumeLink_DblClick(Cancel As Integer)

With Me!txtResumeLink
If Not IsNull(.Value) Then
Application.FollowHyperlink .Value
End If
End With

End Sub

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)
Click to expand...
 
Back
Top