Add hyperlink to PDF file using VBA

[Pelegrinus]

I have a table that contains a field this contains a hyperlink to a PDF file. The field in each record in the table links to a different PDF file. In a small table I can add the hyperlinks manually using the Access menus. But I now have a large table and I want to add the PDF files using VBA. here is the pseudo-language for what I want to accomplish:

For each PDF file in the target Windows target folder

-- put the file name in the appropriate Access field

-- insert a hyperlink to the file itself in the appropriate Access field

---- make the field link display as an icon

Next PDF file

I don't need all the code for this. Rather I need to know where to look in VBA. I've scoured the Help file but haven't found the solution yet.

Thanks.

 

[AlexCuse]

Have a look as the file system object, this will look through the folder for you. You can then use SQL statements to insert the file names and directories, not sure how you would insert a link and make it display as an icon though.

Hope this helps,

Alex

A wise man once said
"The only thing normal about database guys is their tables".