FollowHyperlink question

[Guest]

Hi,

I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contract
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
spot.

Private Sub Toggle1_Click()

Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndName

End Sub

I am not too good with code, so I am hoping it is an easy fix.

Thanks,

 

[fredg]

Hi,

I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contract
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
spot.

Private Sub Toggle1_Click()

Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndName

End Sub

I am not too good with code, so I am hoping it is an easy fix.

Thanks,

You're missing a back-slash after desktop.

DocLocationAndName = "c:\documents and settings\desktop\" & Me.
[contract name]

 

[fredg]

Hi,

I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contract
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
spot.

Private Sub Toggle1_Click()

Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndName

End Sub

I am not too good with code, so I am hoping it is an easy fix.

Thanks,

You're missing a back-slash after desktop.

DocLocationAndName = "c:\documents and settings\desktop\" & Me.
[contract name]

 

[Guest]

Thats what it was. Thanks for the help.

Hi,

I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contract
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
spot.

Private Sub Toggle1_Click()

Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndName

End Sub

I am not too good with code, so I am hoping it is an easy fix.

Thanks,

You're missing a back-slash after desktop.

DocLocationAndName = "c:\documents and settings\desktop\" & Me.
[contract name]

 

[Guest]

Thats what it was. Thanks for the help.

Hi,

I am having trouble getting the FollowHyperlink command to work in a form I
have created. Basically, I have a table with 1 field, contract name. I have
created a form based off of this table, where a user can type in the contract
name, hit a toggle button and a PDF opens for that specific contract name.
So if the pdf file was named test2.pdf, all the person would have to do is
enter test2.pdf in the contract name and hit the button. Problem is, i keep
getting an error message. Could someone please take a look at the code below
and see what I am doing wrong? Also all of the PDF's are kept in the same
spot.

Private Sub Toggle1_Click()

Dim DocLocationAndName As String
DocLocationAndName = "c:\documents and settings\desktop" & Me. [contract name]
Application.FollowHyperlink DocLocationAndName

End Sub

I am not too good with code, so I am hoping it is an easy fix.

Thanks,

You're missing a back-slash after desktop.

DocLocationAndName = "c:\documents and settings\desktop\" & Me.
[contract name]