Creating hyperlink links with VBA?

[David Ball]

Hi,

I have a report that shows the drawings that are related to a particular Part Number. The Part Number is selected from a Combo Box on a Form (frmPartNo). The drawing numbers appear on the report as hyperlinks and by clicking on a hyperlink the user can open a PDF drawing of the part.
I have a lookup table (tblPartNo) that has a column for Part Number (PartNo) and five columns for drawings (Dwg1, Dwg2, etc), as some parts have more than one drawing.
The problem I have is that I have been manually creating the hyperlinks between the table entries and the PDF documents for the drawings and there are a lot of them!
All the drawings are in a single file (Drawings) on my C drive.
Is it possible to use VBA (or some other way) to link to the PDF's rather than having to physically make each hyperlink connection?
Thanks very much
Dave

 

[JHB]

Do you store the hyperlink to the drawing in the table?
Instead of a lookup table, I would suggest you to create a table with only one reference to the drawings per row.