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:
="U:\Common\Layouts\" & Left([PartNumber],2) & "000\" &
[PartNumber] & "-" & [Revision] & "-" & Format([Date],"m-
d-yy")
which is the format of the address for the file location.
Using the On Click event property, I've got the following
code (where Text22 is the unbound field mentioned
earlier):
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 (because when
I print it out in the message box everything looks
correct) and leads to a valid file. Any idea as to what
might be going on?
Thanks in advance,
Jason
fields in my form. I've put the built hyperlink into an
unbound field using this as the source:
="U:\Common\Layouts\" & Left([PartNumber],2) & "000\" &
[PartNumber] & "-" & [Revision] & "-" & Format([Date],"m-
d-yy")
which is the format of the address for the file location.
Using the On Click event property, I've got the following
code (where Text22 is the unbound field mentioned
earlier):
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 (because when
I print it out in the message box everything looks
correct) and leads to a valid file. Any idea as to what
might be going on?
Thanks in advance,
Jason