Display a saved file by clicking on button in Access

[beemomo]

Hi there..

I have a access form which store the information of each invoice with a unique id , for example
"INV 0100" and for each record of invoice there is a related pdf file which belong to it. For instance,
"INV 0100-P85037 belong to invoice "INV 0100".
i did not save the pdf file in invoice table, but what i need is, when i click on the a button "View File", the correspondence pdf file will be displayed for the current record.
Is this make sense ? or i need to save the pdf file into the invoice table in order to reach this?

I am waiting for the solutions as soon as possible, many thanks.

[PianoMan64]

Hi there..

I have a access form which store the information of each invoice with a unique id , for example
"INV 0100" and for each record of invoice there is a related pdf file which belong to it. For instance,
"INV 0100-P85037 belong to invoice "INV 0100".
i did not save the pdf file in invoice table, but what i need is, when i click on the a button "View File", the correspondence pdf file will be displayed for the current record.
Is this make sense ? or i need to save the pdf file into the invoice table in order to reach this?

I am waiting for the solutions as soon as possible, many thanks.

The easist way to figure out what the name of the PDF file is, to store that info in the table. Then when you want to open that just simply execute a SHELL command and include the path and file name of the PDF document.

That should be the easist way to do it.

Hope that helps,

Joe P.

[beemomo]

Dear Joe P:

thanks for your suggestion, i have find a solution for it.
i store the path of the pdf file for each correspondence record in the invoice table by clicking on a browse dialog button on the form. Then the field for storing the path name is set to "Hyperlink" data type, therefoe the user can just click on the hyperlink that appears on the form to open the pdf file.

Cheers.