Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Launchlink problem

Status
Not open for further replies.

Costefran

Technical User
Jan 2, 2008
197
GB
Hello
Can anyone help
I was given some code by a kind knowledgable friend that enabled the user in my DB to create a link to a document and place the link in a label on my form

I thought I could use it in another DB and all would work fine. Unfortunately this is not the case and I now get a "compile error" "sub or function not defined" and when I debug the following line is highlighted in yellow

atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])


I am a total novice regarding this code and any help, explained in basic terms would be very much appreciated

Thanks

The code is below

Private Sub CREATE_LINK_BUTTON_Click()
Dim atmpfield As String
atmpfield = Launchlink([Forms]![Enquriy Form]![CATEGORY WORKS TABLE SUBFORM])
If atmpfield <> "" Then
[Label1].Caption = atmpfield
[Hyperlink] = atmpfield
[Label1].HyperlinkAddress = [Hyperlink]
Me.Dirty = False
End If

End Sub
 
Look for a sub or function called Launchlink.
 
Remou

Many thanks and have found it and it works

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top