Solved

Hyperlink to pdf on local drive

Posted on 2014-03-05
6
384 Views
Last Modified: 2014-03-07
Hi,

(I raised this last week and never fully resolved it).

1. I have a form with a hyperlink in it.

2. I then use the form to enter a link to a local pdf file.

3. After this I click on the link and the pdf should open.

In the database attached.
Please use the form to insert a PDF file from your local drive onto the hyperlink.

Then save the record, and then see if you can click on the hyperlink.
Can you get the pdf to open. (Same applies with other formats)

Why can't I open my pdf when I click on the link?


PS: The VBA was supplied by an expert and ALMOST does exactly what I want.
dbselectfile.accdb
0
Comment
Question by:Patrick O'Dea
  • 3
  • 3
6 Comments
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
I can't download the file where I am.

I never use the hyperlink data type since it isn't supported by SQL Server.  I use a standard text column.  In code, I use the FollowHyperlink method which will use Windows to determine which application to launch based on registry settings and open the correct application.  So if the file extension is .xls, Excel will open, if it is .txt, notepad will open, if it is .doc, Word will open.  If it is a web address, a web page will open up.  To make it look like a hyperlink, set the Display as Hyperlink property to Always on the property sheet.
0
 

Author Comment

by:Patrick O'Dea
Comment Utility
Thanks Pat,

I am looking at FollowHyperLink .. it's new to me!

Is it possible to set a textbox = Application.FollowHyperlink strInputByUser??

... I am little beyond my comfort zone.

Ideally, if someone could download my database and tweak it!
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
No, you would reference another text box if you wanted the user to specify.

Application.FollowHyperlink Me.InputByUser

Here is a code sample taken from an application where I use it.  The form is bound so I save the current record first if it is dirty.  These are links I stored internally and I do not store the path with the file name for this application because I want to make it easy for the client to move the directories to a different location.  So, the code concatenates the path with the document name from the text box.

Private Sub cmdOpenDoc_Click()
    Dim strInput As String
    
On Error GoTo Err_cmdOpenDoc_Click
    If Me.Dirty Then
        DoCmd.RunCommand acCmdSaveRecord
    End If

    If Right(Me.ScannedDocPath, 1) = "\" Then
        strInput = Me.ScannedDocPath & Me.txtFullDocName
    Else
        strInput = Me.ScannedDocPath & "\" & Me.txtFullDocName
    End If
    
    Application.FollowHyperlink strInput, , True

Exit_cmdOpenDoc_Click:
    Exit Sub

Err_cmdOpenDoc_Click:
    Select Case Err.Description
        Case 2501
            Resume Next
        Case 490    '   cannot open file
            MsgBox "This file cannot be found.  Please check its name and path.", vbOKOnly + vbInformation
            Exit Sub
        
        Case Else
            MsgBox  Err.Number & "--" &  Err.Description
            Resume Exit_cmdOpenDoc_Click
    End Select
    
End Sub

Open in new window

0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:Patrick O'Dea
Comment Utility
Thanks for advice ..

I have tried the VBA provided and some other stuff too.
I am coming across a number of problems ...
A whole variety of issues arising and I am losing my enthusiasm!


Would it be possible to send me a very simple db with a hyperlink facility.
0
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
Use the ... button to select any registered file type.  Then click the Open button to open it.   It will even work to open web pages if you use the full name ---

http://www.fmsinc.com/
HyperLinkSample140306.zip
0
 

Author Closing Comment

by:Patrick O'Dea
Comment Utility
Pat,

Thanks for that.
It works very well.

(Now, I have to make sure that I don't break the golden rule! - I must try to understand the VBA - or at least most of it).
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now