I have MS Access with one table and 3 fields. The Fields are ID, FileName and FilePath. I need to write a VBA to link the FilePath field to Open Acrobat Professional and not the Reader and when I go to next Record the Acrobat remain static only the image changes. I have tried the OLE and also the Hyperlink method. I cannot get the OLE working at all but for Hyperlink the Acrobat does not stay static it closes and then reopens when I go to click the next record Hyperlink. All of my PDF files are in one Directory called PDFFiles and they are numbered 1_0001.pdf and so on.
