Question Locked

VBA to link Acrobat Writer in MS Access

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

1 reply

This discussion is closed to new replies.