Problems with Hyperlink

[Guest]

I have a form that contains everything I need to populate a hyperlink field
on another form. When I try to insert the value into the hyperlink field I
get an "error communicating with Ole Server or Activex control"

Here is what I have:
CallingControl = Forms![formname]![controlname] *Hyperlink
FullPath = c:\data\filename

I have tried CallingControl.value = FullPath,
CallingControl.HyperlinkAddress = Fullpath among others.

Do I need to insert # into the string?

Thanks in advance for any help.

 

[Guest]

For one thing you are missing quote for the FullPath variable.

FullPath = "c:\data\filename"

Shouldn't you have include the extension?

FullPath = "c:\data\filename.ext"

 

[Guest]

Thanks for the quick reply.

The FullPath is coming from a textbox, do I need to add the ""? The
filename has an extension. Sorry, I was not explicit.

For one thing you are missing quote for the FullPath variable.

FullPath = "c:\data\filename"

Shouldn't you have include the extension?

FullPath = "c:\data\filename.ext"
--
Hope this helps,

Daniel P

I have a form that contains everything I need to populate a hyperlink field
on another form. When I try to insert the value into the hyperlink field I
get an "error communicating with Ole Server or Activex control"

Here is what I have:
CallingControl = Forms![formname]![controlname] *Hyperlink
FullPath = c:\data\filename

I have tried CallingControl.value = FullPath,
CallingControl.HyperlinkAddress = Fullpath among others.

Do I need to insert # into the string?

Thanks in advance for any help.

 

[Guest]

Then in that case you need something like

FullPath = Me.TextboxName

Where TextboxName is the actual name that you've given to the textbox in
question on your form. You can determine this by opening your form in design
mode and going into the properties.

No need for quotes.
--
Hope this helps,

Daniel P

Thanks for the quick reply.

The FullPath is coming from a textbox, do I need to add the ""? The
filename has an extension. Sorry, I was not explicit.

For one thing you are missing quote for the FullPath variable.

FullPath = "c:\data\filename"

Shouldn't you have include the extension?

FullPath = "c:\data\filename.ext"
--
Hope this helps,

Daniel P

I have a form that contains everything I need to populate a hyperlink field
on another form. When I try to insert the value into the hyperlink field I
get an "error communicating with Ole Server or Activex control"

Here is what I have:
CallingControl = Forms![formname]![controlname] *Hyperlink
FullPath = c:\data\filename

I have tried CallingControl.value = FullPath,
CallingControl.HyperlinkAddress = Fullpath among others.

Do I need to insert # into the string?

Thanks in advance for any help.

 

[Guest]

That is what I am doing. I am capturing the name of the control and the name
of the doc, appending the name of the doc to the path and trying to insert
into hyperlink.

Then in that case you need something like

FullPath = Me.TextboxName

Where TextboxName is the actual name that you've given to the textbox in
question on your form. You can determine this by opening your form in design
mode and going into the properties.

No need for quotes.
--
Hope this helps,

Daniel P

Thanks for the quick reply.

The FullPath is coming from a textbox, do I need to add the ""? The
filename has an extension. Sorry, I was not explicit.

For one thing you are missing quote for the FullPath variable.

FullPath = "c:\data\filename"

Shouldn't you have include the extension?

FullPath = "c:\data\filename.ext"
--
Hope this helps,

Daniel P





:

I have a form that contains everything I need to populate a hyperlink field
on another form. When I try to insert the value into the hyperlink field I
get an "error communicating with Ole Server or Activex control"

Here is what I have:
CallingControl = Forms![formname]![controlname] *Hyperlink
FullPath = c:\data\filename

I have tried CallingControl.value = FullPath,
CallingControl.HyperlinkAddress = Fullpath among others.

Do I need to insert # into the string?

Thanks in advance for any help.