Hyperlink

J

Jason

I'm trying to build a hyperlink from some different fields
in my form. I've put the built hyperlink into an unbound
field using this as the source code:

="U:\Common\Layouts\" & Left([PartNumber],2) & "000\" &
[PartNumber] & "-" & [Revision] & "-" & Format([Date],"m-d-
yy")

Using the OnClick event property, I've got the following
code:

Private Sub Text22_Click()

Dim ctl As CommandButton
Set ctl = Me.Command24
MsgBox (Me.Text22)
With ctl
.Visible = False
.HyperlinkAddress = Me.Text22
.Hyperlink.Follow
End With
End Sub

When I run the code, I get the following error:

Run time error '432':

File name or class name not found during Automation
operation.

I know that the hyperlink built is correct and leads to a
valid file. Any idea as to what might be going on?

Thanks in advance,

Jason
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top