Using PDF's

[Krefty]

Hello and Thanks for reading my issue.

I have 7 PDF files, I don't really care if they stay as PDF's but I would
like to link a button to open the Exteranal form at a specific location with
the use of a push button??? Does that make sense???

Please let me know if you know anything that can assist me.

 

[John Nurick]

Hi Krefty,

Assuming that you're talking about a CommandButton on an Access Form,
just put this in the button's Click event procedure:

Application.FollowHyperlink "D:\Folder\Sub folder\Document.pdf"

substituting the actual name and location of the PDF file you want to
open.

 

[Krefty]

John,
I am not sure where to enter the file path name???

When I attempt to create a "Command Button" what Command Button Wizard
function do I choose???

If I need to bypass that wizard function and go directly to the Command
Button do I directly type the path as such

Application.FollowHyperlink "S:\_EmergencyStandby\GC Documentation\Emergency
Call Flow Charts\visio-fire call v1.pdf"

That is the exact file name??? Where does it need to be inserted???

Thanks in advance.....

 

[John Nurick]

Don't use the commmand button wizard (or click Cancel when it appears).

Then
-make sure the commandbutton is selected
-display its Properties (it's on the View menu if needed)
-click on the Other tab of the properties sheet and give the button a
convenient name (e.g. cmdOpenPDF1)
-click on the Format tab and set the Caption property to what you want
to show on the face of the button
-click on the Event tab of the Properties sheet
-click in the On Click text field and select [Event Procedure] from the
dropdown list.

Now click the [...] button next to the text field. This takes you to the
button's Click event procedure in the form's code module. This will look
like this:

Private Sub cmdOpenPDF1_Click()

End Sub

The Application.Hyperlink statement goes between those two lines.

 

[Krefty]

Thanks John
I get the following error;
Private Sub cmdOpenFlow_Click()
Application.Hyperlink "S:\_EmergencyStandby\GC Documentation\Emergency Call
Flow Charts\Visio-CO Call 11-10-05 v3.pdf"
End Sub

The word hyperlink is highlighted??? Did I miss something?
Thanks for your detailed assistance.

Don't use the commmand button wizard (or click Cancel when it appears).

Then
-make sure the commandbutton is selected
-display its Properties (it's on the View menu if needed)
-click on the Other tab of the properties sheet and give the button a
convenient name (e.g. cmdOpenPDF1)
-click on the Format tab and set the Caption property to what you want
to show on the face of the button
-click on the Event tab of the Properties sheet
-click in the On Click text field and select [Event Procedure] from the
dropdown list.

Now click the [...] button next to the text field. This takes you to the
button's Click event procedure in the form's code module. This will look
like this:

Private Sub cmdOpenPDF1_Click()

End Sub

The Application.Hyperlink statement goes between those two lines.

John,
I am not sure where to enter the file path name???

When I attempt to create a "Command Button" what Command Button Wizard
function do I choose???

If I need to bypass that wizard function and go directly to the Command
Button do I directly type the path as such

Application.FollowHyperlink "S:\_EmergencyStandby\GC Documentation\Emergency
Call Flow Charts\visio-fire call v1.pdf"

That is the exact file name??? Where does it need to be inserted???

Thanks in advance.....

 

[Krefty]

From your great details I figured out that I was missing the word "follow" in
front of hyperlink....

Im GOLDEN now..

Again Thanks

Don't use the commmand button wizard (or click Cancel when it appears).

Then
-make sure the commandbutton is selected
-display its Properties (it's on the View menu if needed)
-click on the Other tab of the properties sheet and give the button a
convenient name (e.g. cmdOpenPDF1)
-click on the Format tab and set the Caption property to what you want
to show on the face of the button
-click on the Event tab of the Properties sheet
-click in the On Click text field and select [Event Procedure] from the
dropdown list.

Now click the [...] button next to the text field. This takes you to the
button's Click event procedure in the form's code module. This will look
like this:

Private Sub cmdOpenPDF1_Click()

End Sub

The Application.Hyperlink statement goes between those two lines.

John,
I am not sure where to enter the file path name???

When I attempt to create a "Command Button" what Command Button Wizard
function do I choose???

If I need to bypass that wizard function and go directly to the Command
Button do I directly type the path as such

Application.FollowHyperlink "S:\_EmergencyStandby\GC Documentation\Emergency
Call Flow Charts\visio-fire call v1.pdf"

That is the exact file name??? Where does it need to be inserted???

Thanks in advance.....