Placing a link in Access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bill Sublette
    New Member
    • Jul 2010
    • 24

    Placing a link in Access

    My question is... Is there a way to place a link to a .pdf file into Access where if you click it from a database it will pull up the file? I don't think there is but it's worth the time to ask. Thanks.
  • Bill Sublette
    New Member
    • Jul 2010
    • 24

    #2
    Nevermind... I answered my own question via trial and error. Apparantly you can. It's not pretty but it works... lol

    Comment

    • Jerry Maiapu
      Contributor
      • Feb 2010
      • 259

      #3
      How did you manage to get it..

      Comment

      • Bill Sublette
        New Member
        • Jul 2010
        • 24

        #4
        Within the tables you can insert a hyperlink column and from there just edit the hyperlinks to the file you want to pull up. I copied and pasted the names of the files into the hyperlink column and that was it. Pretty simple but if you have quite a few links to update, it may take a while. I actually decided to bypass the entire ordeal and did it in Excel.

        Comment

        • TheSmileyCoder
          Recognized Expert Moderator Top Contributor
          • Dec 2009
          • 2322

          #5
          There are several ways to do it, depending on how much time you want to spend, and how elegant you want it.

          You can make a button which opens a filebrowser and then simply browse to the file(s), select them, and have the code store the info in the hyperlink field. You can also make code/form that mimics a file-browser but with more customised properties and abilities depending on your needs.

          Comment

          Working...