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