Open a specific file

[ngs88]

I have a database form on from which I wish to be able to open a specific pdf file. The file name used is the same as the record number field (Customer No) ie Customer No 555, file required is 555.pdf

Can anyone help with a method or code so that the file will automatically open the pdf file relevant to that record when I click a command button or something.

I tried putting a link in a bound object frame which should give an adobe icon but it throws an error message about active x or something and althogh I have done all that microsoft says should resolve it the problem still remains hence looking for another way


Please be clear as I am a novice at using code

Thanks John

 

[Krava]

Hi, ngs88!

I use a similar thing and I have made it simple:

In the form, on event OnCurrent I setup HyperlingAddres of the button= FULL PATH to document (Path\Fielname).
Then, when I click the button after selecting the item from the form, system opens the document automatically.

Hope it was clear enough.

Krava

 

[Ron_dK]

I have a database form on from which I wish to be able to open a specific pdf file. The file name used is the same as the record number field (Customer No) ie Customer No 555, file required is 555.pdf

Can anyone help with a method or code so that the file will automatically open when I click a command button or something.

Please be clear as I am a novice at using code

Thanks John

John,

You might do a search on 'Access pdf' on this forum, lots of hits and examples.

Hth