Results 1 to 2 of 2
  1. #1
    jaworski_m is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jan 2015
    Posts
    25

    Insert hyperlink - ensure absolute path


    Hello,

    I use the following code to insert a hyperlink.

    Code:
    Private Sub cmdInsertHyperlink_Click()
       'Opens hyperlink dialog
       On Error GoTo ErrEditHyper
       Me.link.SetFocus
       DoCmd.RunCommand acCmdEditHyperlink
       Exit Sub
    ErrEditHyper:
    ' error handling
    End Sub
    How can I make sure than only absolute path to a file is stored?

    Thank you for advice.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Maybe don't use the hyperlink wizard and save name of the file you want to open just as normal text.

    Review:
    http://www.allenbrowne.com/casu-09.html
    http://allenbrowne.com/func-GoHyperlink.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 05-27-2014, 05:41 AM
  2. Replies: 22
    Last Post: 04-24-2014, 01:56 PM
  3. Replies: 5
    Last Post: 10-28-2013, 08:09 AM
  4. Replies: 3
    Last Post: 07-30-2012, 02:16 PM
  5. how to insert a hyperlink?
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 09-16-2010, 07:37 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums