FollowHyperlink question

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10296-followhyperlink-question.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296

End Sub

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

Thanks,

Do you agree or disagree with the writer above? Why not share your immediate thoughts with us! Login Now! or Sign Up Today! to share your views... Gurfateh!

On Thu, 25 May 2006 0802 -0700, justin wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296
[contract name]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thats what it was. Thanks for the help.

"fredg" wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296
> On Thu, 25 May 2006 0802 -0700, justin wrote:
>
> > 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]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10296
> > 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]
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>