Linking form to PDF file

[Frank]

Looking for help: I have a client database and want to
open scanned PDF (Adobe Acrobat Doc)documents while in a
form. The pdf is saved under the auto number of the client
record. Can you please help.

 

[Arvin Meyer]

Looking for help: I have a client database and want to
open scanned PDF (Adobe Acrobat Doc)documents while in a
form. The pdf is saved under the auto number of the client
record. Can you please help.

Until Acrobat 5.0, you could open a pdf inside an Access for. Adobe broke
that by changing Acrobat 5. If you can get a copy of the 4.0 or 4.05 reader,
the ActiveX control still works.

Failing that, using the ShellExecute api will open any file in its
registered program, and does work with pdf files:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Chris Wagner]

After looking at the .mvps. site and not being very knowledgeable in Access I
was hoping for something different. BTW I do enjoy the mvps site... thanks....
and have been there before.

My guess there is no easy way (i.e. a button) to push for this one. My guess
is that I would make a button huh?

What I am working with is
Table A has an ID number
I have about 500 .pdf files
Within the pfd file name is the ID number
What I had envisioned was... on a given record... showing on the screen...
there would be a sub form showing the names pdf's relating to that record.
(sometimes 3 or 4 pdf files)
From there one could click on the filename and it would open Acrobat Reader and
display the .pdf.

Where would one place the code shown on the .mvps. site or is that a whole
different type of programming? Is it something that is added in the form
properties? I'm still back creating forms and slowly learning.

I've been looking through 'Running MS Access 2000' to try to find some
answers. If you know of a section in that and could point me in the right
direction that would be very helpful.

Thanks
Chris Wagner