Results 1 to 4 of 4
  1. #1
    jip911 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2

    Question VBA to assign address to Hyperlink

    I recently converted a large spreadsheet to an access table to allow multi-user entry/access to the data and am having troubles with one column that was a hyperlink in excel.

    The column is named "location" and has the full path to the file I am trying to hyperlink to eg.
    M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-014 01_R0.PDF
    M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-015 01_R0.PDF


    M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-016 01_R0.PDF
    M:\DCONTROL\Public\5194 DOCUMENTS\Drawings\010 - General\073-1413-010-017 01_R0.PDF

    I set the data type of the column "location" to hyperlink and all the data turned blue/underlined like a hyperlink but the address of each hyperlink is blank. I am having to go set the hyperlink address manually for each file by copying the "text to display" to the "address" field

    Is there some code out there I can run to set the address of these links to match the "text to display"

    Thanks
    J

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,795
    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.

  3. #3
    jip911 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    2
    Thanks so much! I searched all over for this and came up blank.... This simple solution worked
    Option 1:
    After you import the data into Access…
    1. Change the table to design view
    2. Change the datatype of the hyperlink field to memo
    3. Save the table
    4. Change the datatype from memo back to hyperlink
    5. Save the table
    6. Open the table in datasheet view
    7. Test your hyperlink field

  4. #4
    ClassicVinyl is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2018
    Posts
    7
    goofed where I posted
    Last edited by ClassicVinyl; 08-02-2018 at 04:45 PM. Reason: goofed where I posted

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

Similar Threads

  1. Replies: 4
    Last Post: 01-31-2011, 03:19 PM
  2. Get Mac Address
    By Mclaren in forum Programming
    Replies: 4
    Last Post: 05-02-2010, 12:34 PM
  3. Replies: 1
    Last Post: 10-07-2009, 08:15 AM
  4. Input Mask for an IP Address and Mack Address
    By baksg1995 in forum Access
    Replies: 18
    Last Post: 06-23-2009, 12:33 PM
  5. assign value from list
    By roman.pro in forum Forms
    Replies: 0
    Last Post: 05-16-2009, 04:20 PM

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