file hyperlinks

[HOJU15]

I want the hyperlink field to take the value of a another field (job in this case) and use it in the hyperlink address

i.e. two fields - job and hyperlink

jobs are numbers that corresond to autocad files (O-1900.dwg) that are on a file server)

i want the hyperlink field to have the link to the file (z:/job number.dwg)

how can I do this. There are 1100 records so I want to automate not type in the hyperlink address myself

 

[shahid]

Why not make the hyperlinks on the run time instead of storing them into separate field, which will cause too much repetation.

An example of ASP code:

<%
strURL = Server.Mappath(rsData("job"))
response.write "<a href='" & strURL & "'>Link Text</a>"
%>

the string strURL will contain the actual physical path to the file.
rsData will be your recordset.

 

[Fornatian]

Alternatively, simply use the Application.FollowHyperlink method to pass a string as the Hyperlink route, as follows:


Application.FollowHyperlink "z:/"& Me.MyJobNumberField & ".dwg"