Problems with Hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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"
 
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.

Daniel said:
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





Tim Reid said:
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.
Click to expand...
Click to expand...
 
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




Tim Reid said:
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.

Daniel said:
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





Tim Reid said:
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.
Click to expand...
Click to expand...
Click to expand...
 
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.

Daniel said:
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




Tim Reid said:
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.

Daniel said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top