Command Button to Open EXTERNAL file (any kind)

[Guest]

I have a database with employee information and I use a form called EMPINFO.
I have scanned 5 pages of information for each employee which I have them on
PDF format on a separate drive. Each employee on the form has a unique number
(primary key).

- I want to be able to have a command button, that will open the PDF file of
that specific employee. I tried doing it with reports but it is being too
time consuming. Basically the command button needs to run a query that will
select the employee number currently on screen, and it will open the PDF file
of that employee! Please help.

I know how to do hyperlinks with the command buttons, but it would be too
many buttons if I have to add one command button for each employee with a
hyperlink.

 

[Guest]

Sorry I forgot to mention I am using Access 2000. Thanks!!

 

[Albert D.Kallal]

You can launch any file as if you clicked on it by using:


application.FollowHyperlink "c:\docuemnts\test.doc"

or

application.FollowHyperlink "c:\docuemnts\test.pdf"

So, just use a buttion with some code:

application.FollowHyperlink me!FieldNameWithdocumentpath

 

[Guest]

Yes, each PDF file has the employee number as the file name. So the File Key
is always the same as the PDF file name.

 

[Rick Brandt]

I have a database with employee information and I use a form called
EMPINFO. I have scanned 5 pages of information for each employee
which I have them on PDF format on a separate drive. Each employee on
the form has a unique number (primary key).

- I want to be able to have a command button, that will open the PDF
file of that specific employee. I tried doing it with reports but it
is being too time consuming. Basically the command button needs to
run a query that will select the employee number currently on screen,
and it will open the PDF file of that employee! Please help.

I know how to do hyperlinks with the command buttons, but it would be
too many buttons if I have to add one command button for each
employee with a hyperlink.

Are the PDF files consistently named such that the only thing different is
the inclusion of the employee number in the file name? If so...

Application.FollowHyperlink "PathToPDFFolder" & Me.EmployeeNumber & ".PDF"