OPEN PDF FILES FROM WITH IN ACCESS 2000

[GaryB]

Hi,

This particular problem has me perplexed. We are running Access 2000 and cannot upgrade for numerous reason. I need to be able to open pdf files from within Access. What I would like to have happen is to be able to click a command button and have it collect the job number information from the form that is opened ( numbered forms ) and then have it go to a folder that holds all of the pdf files by job number and select and open that specific one. Is something like this even possible to do and also automate like this?

Thanks,

Gary
go to www.bigbadjazzdaddy.com and click the like button, please.

[Tommy]

Go to references, select the adobe acrobat browser control.
Embed on a form.
to show the pdf file use this command
AcroPDF1.LoadFile (pdfPath & PDFfilename & ".pdf")
AcroPDF is the control name of the adobe browser control.

[GaryB]

Hi Tommy,
If I am looking at this right, I would have to manually enter the path and filename for each pdf I wanted. Am I correct?

Thanks,
Gary

[Tommy]

Yes that is correct, just do a

FileName = dir ("job number information from the form that is opened" & "*.pdf")
If FileName <> vbnullstring then

Unless I am missing something?