Opening Adobe PDF using Microsoft Access 2003

[rixter67]

I need a little help here. I have an Access 2003 database and and external folder with several PDF files in it. I want to be able to open the PDF file from a link to a particular Access file. For example: I have check request number in Access, the PDF files are not in the database. I need to get the certain request number linked to the PDF request.

Any suggestions are appreciated. TIA

 

[ETID]

Assuming that you want the user to type a check request number into a form and have it automatically become a hyperlink to a pdf doc of the same name...

then

the code on a form event of your choice...

me.chk_request_num=CStr(me.chk_request_num)+"#File:c:\my_path\"+CStr(me.chk_request_num)+".pdf#"

...be sure that chk_requst_num field's data type is set to hyperlink in the table in which the form field is bound.