hyperlinks

[Guest]

I need to update a very large database (20k records) with hyperlinks that
direct users to pdf files on our server. How can I auto-update the
hyperlinks, using data from 2 fields in the database, something along the
lines of "H:\MainFolder\NextFolder{Value from Year Field}\{Value from
FileNumber Field}.pdf" ? I can find nothing that tells me how I can use an
update query to modify the property values of a hyperlink field. (Also, I
want the appearance of the link to be simply the value in the FileNumber
field, and not a long monstrosity of a hyperlink address.)

 

[Guest]

I gather form reading this that the [Year field] and [file Number field] are
the same as file name you want to link to ie 2005book.pdf.

If so and your user accesses the link from a Form, the process is quite easy
and the presention of the link quite tidy and best handle via a short amout
of vb code.

Let me know if this is the case and i will post an example, if i am way of
the mark give a clue and I think again

Davidj