If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hyperlink
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 |
#2
|
|||
|
|||
Hyperlink
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 -- ~Your Friend Chris http://myvbastuff.blogspot.com/ thinking out loud "Denver" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|