Hyperlink

[Denver]

i have a field in my table to name Link PDF and Link DGN
Field Type Hyperlink...

i have already 12 thousand records and i want that all my records have a
link to PDF and DGN using Hyperlink.

is there a way to just one click and all of my records will have each
hyperlink path
without doing it invidual setting hyperlink?

i dont want to do right click, then click hyperlink then so on and so forth
for each records that i have. Because i have around 12 thousand records, so
to save time is there a way that i can do this in access 2003?

hope there is anyone is kind to give me some help and suggestions.

thanks

denver

 

[vbasean]

Question: How does your current data relate to the location of the PDF/ Link
DGN?

Do you have a file name or a path already stored in the database?

if this is so, then all you really need to do is create a hyperlink field
and run an update query with the path placed in it.

the Hyperlink field can consist of two items separated and ended by the #
octothorp or pound sign.

for example:
myfile.pdf#C:\My Documents\Some Folder\myfile.pdf#

depending on what data you have and the file location. For example, you
have a file name and all these files reside in the same folder:
MyHyperlinkfield = [FileName] & "#" & [PathToFile] & "#"
via an update query