By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,783 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Display a saved file by clicking on button in Access

P: 50
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.
Feb 18 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
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.
Feb 18 '08 #2

P: 50
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.
Feb 19 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.