Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 313
  • Last Modified:

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?
0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 3
  • 2
2 Solutions
 
ambri5hCommented:
What is the code that the Hyperlink uses?

Check that to see how its connecting to the folder/file... Also check permissions on the folders in case that has any bearing on it.
0
 
mbizupCommented:
<<See attached.>>

Your attachment got left behind.
0
 
Patrick O'DeaAuthor Commented:
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

0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
Patrick O'DeaAuthor Commented:
See attached ... forgot to attach earlier!
0
 
mbizupCommented:
Are you trying to attach a sample database file?

It did not get attached.
0
 
Patrick O'DeaAuthor Commented:
Folks,

I will close this question and give goodwill marks!

I have resolved the issue and was not presenting things correctly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now