Can I update all of the hyperlink entries in a given field using .

[kwanlu]

I am trying to convert the entries in a single field in a 2000-record
database to hyperlinks which will allow users to directly access pdf
documents on our shared drive. the hyperlinks follow an identical format
(e.g., "H:\OurStuff\UsefulData\2004\FIleNumNN-04.pdf".

Is this possible, or do I have to update each record individually (which
sucks...)

 

[Allen Browne]

Use an Update query to modify the contents of the hyperlink field.

Be sure to back up first, as it's easy to mess this up.

If you are not sure of the various parts that make up the hyperlink field,
see:
Introduction to Hyperlink fields
at:
http://members.iinet.net.au/~allenbrowne/casu-09.html