Creating Hyperlink in access 2010 via VBA

[AdamT]

Greeting to all,



I have a table. Within this table I have three fields Item, Qty, and Part Number. The Part Number field could have several drawings number associate with it (i.e. 100, 101,102,....). These drawing is in PDF format. I would like to create a Hyperlink on each drawing which then allow the user to click on this field and open up the file in PDF format. These drawings resided on server at specific folder.

V/r
Adam

[AlexHedley]

You can use

Application.FollowHyperlink

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

Store the Server path in a table.
Use a DLookup to get it then concatenation (&amp that with the filename that is also stored you table.
Add this to a button to then open your file.