Use ID field as a Hyperlink

[Supraracer]

Access 2007

I have a Quote table which has the Quote_ID field. When I do a report listing the quoted jobs I would like to click on the Quote_ID and have it open a scanned PDF file of the quote. I know how to do this using the Hyperlink Data Type but Quote_ID is a number and I don't want to edit all the URL's. Maybe something in VBA to open the hyperlink. All the files path's will be "\\Server\Data\" and all the files will be the same as the Quote_ID with the pdf extension. For example

Quote number 206 = "\\Server\Data\206.pdf"

Thanks,

John

 

[boblarson]

You can put together a hyperlink for a form that would open based on what record you are on:

Dim strLink As String

strLink = "\\Server\Data\" & Me!YourFieldNameWithTheID & ".pdf"

FollowHyperlink strLink

 

[Supraracer]

You can put together a hyperlink for a form that would open based on what record you are on:

Dim strLink As String
 
strLink = "\\Server\Data\" & Me!YourFieldNameWithTheID & ".pdf"
 
FollowHyperlink strLink

You guys are great. I just didn't know the command and it works great.

Thanks so much.

John

 

[boblarson]

You guys are great. I just didn't know the command and it works great.

Thanks so much.

John

No problem. Glad it is working for you.

 

[brickelldb]

Thank you from me too!

You guys resolved my problem on a similar issue I was having naming images to the record ID. Came across on a search. THANKS!!

 

[boblarson]

Thank you from me too!

You guys resolved my problem on a similar issue I was having naming images to the record ID. Came across on a search. THANKS!!

And THANK YOU for actually searching (more people should try that )