Link to PDF's

[HUMMER87]

Hi All



I was just looking for a little advise.

I have a database which is in need of some TLC, its fully functional however would like to try and implement an idea I have.

Basically I have a folder with loads of PDF's in. These PDF's are named 18000, 18001,18002 lets say for arguments sake.

And on a regular basis new PDF's are added to this folder.

Within my Access database I have these numbers generated consecutively.

My question, is there a way for me to implement a button on to one of my forms that would allow access to go to this folder where all the PDF's are stored look up the consecutive number on the record I have open and open the PDF that corresponds with it.

It all sounds a little pie in the sky but I am sure someone must have tried a similar thing.

I would be greatly appreciative of any support as I am struggling to come up with a solution. Its a long while since the database was built so I am having to go over my footsteps to remember things.

Look forward to any responses

Many Thanks in advance

Tom

[RuralGuy]

You say you have a record open with the consecutive number of the PDF you want? Are the files named 18000.pdf for example. Are they always in the same directory? If so, then of course you can do this.

[HUMMER87]

Yep the files at the moment are not but they will be and yes they are all in the same directory

[RuralGuy]

You would need the complete path name concatenated with the number and ".pdf" passed to the following procedure:
http://access.mvps.org/access/api/api0004.htm

[HUMMER87]

Thanks for getting back to me not overly sure exactly what you mean... When I built my database I never implemented code :-S so am a little unsure as to how to attempt your suggestion

Many thanks

[RuralGuy]

The link I supplied goes in a Standard Module named basCode. Then add a Command Button to your form that uses code and goes to a record. Then post the code in the button and we will modify it for you to open the PDF.