How to Create a Button that Opens a PDF file in a specific Page

[MMMSOARES_2011]

Hello

I´d like to create a button (in a form) that will open a pdf file in a specific page. I found this code bellow in another forum and it worked fine, but the problem is that, in my case, both the path of the file and the specific page in wich i want it to open at are fields of a table. So please i´d like to adapt this code to make it work for me or i´d like to get another code that would also work. Please give me the full syntax. Thank you very much in advance!

Shell Chr$(34) & "C:\PathToAcrobat\Acrobat.exe" & Chr$(34) & _


" /A " & Chr$(34) & "page=2=OpenActions" & Chr$(34) & _
Chr$(34) & "C:\PathToFile\MyFile.pdf" & Chr$(34)

In my case:

The number of the page is stored in the field called Section_Begin_Page of a table called 5_Section

The path of the pdf file to open is stored in the field Volume_link of a table called 3_Volume

Thank you very much in advance!

[June7]

Concatenating a variable into the Shell statement is easy. The trick is figuring out how to retrieve the values from tables. Do you have that part resolved?

Shell Chr$(34) & "C:\PathToAcrobat\Acrobat.exe" & Chr$(34) & _
" /A " & Chr$(34) & "page=" & pagevariable & "=OpenActions" & Chr$(34) & _
Chr$(34) & filepathvariable & Chr$(34)

[MMMSOARES_2011]

Hello, June7

Sorry for my late reply. In the first 2 days i had no replies so i focused in other problems and stopped watching this forum. That was exactly when you came with your message. Thank you very much for the attention!

I solved this problem with the help of people from another forum. No code would work. And i found 3 different ways of doing it, 3 right codes that wouldn´t work here. In the end i discovered that it was all caused by the fact that the field with the "path to file" was defined as LINK, not as TEXT. So now it´s solved.

Thank you very much anyway!