asked on

Hyperlink follow up question

Hi ,

See attached.
An EXPERT gave this neat utility.

It allows me to insert a hyperlink into my form
Specifically I am inserting a folder & file name.

However, after saving the record .... I then click on the hyperlink - it does not open my file...??
Why not?

ASKER CERTIFIED SOLUTION

ambri5h

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Patrick O'Dea

ASKER

Permissions are fine..
It's all a bit odd and is best understanding by actually running the simple form.

(Perhaps if might behave differently on someone else's PC)

http://screencast.com/t/VGNPFa9k23

Option Compare Database

Private Sub cmdSelectFile_Click()

Me.txtfile = SelectFile


End Sub

Function SelectFile() As String
      
        On Error GoTo ExitSelectFile
          
        Dim objFileDialog    As Object
        Set objFileDialog = Application.FileDialog(1)
          
        With objFileDialog
          
            .AllowMultiSelect = False
            .Show
               
            Dim varSelectedItem As Variant
      
            For Each varSelectedItem In .SelectedItems
      
                SelectFile = varSelectedItem
               
            Next varSelectedItem
                  
       End With
         
ExitSelectFile:
      
    Set objFileDialog = Nothing
      
End Function

Open in new window

Patrick O'Dea

ASKER

See attached ... forgot to attach earlier!

mbizup

Are you trying to attach a sample database file?

It did not get attached.

Patrick O'Dea

ASKER

Folks,

I will close this question and give goodwill marks!

I have resolved the issue and was not presenting things correctly.