Hyperlink?

[NewfieSarah]

Hey all,
I have a table for my documents and I have to add all these documents which need to be entered into the table, is there a faster way then right click edit hyperlink and go through the folders and find the file? Since I have a lot of doc this will take a while so I was wondering if there was another way? Thanks

 

[Remou]

You can use Dir or the File System Object to add all the file names to a text field. You can use FollowHyperlink to open the files, or if you want to convert the text to a hyperlink field, it will look like FileName#

http://FileName#,

which you can build with an update query.

    strTemp = Dir$(strFileNames, vFileType)
    Do While Len(strTemp) <> 0
        strFileList = strFileList & strTemp & strDelim
        strTemp = Dir$()
    Loop