Results 1 to 2 of 2
  1. #1
    amer is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    14

    Where is the hyperlink....

    Ok I'm in the datasheet view and I need to change the hyperlinks in one of the fields.

    I did a search query to find all the records I want to update in my update query but it doesn't find the hyperlinks. It finds the text field.



    How do I get the query to find the actual hyperlink. I know I can use F2 to see the hyper link but that's going one by one. I have 1800 records so I need to use the query to find all the hyperlinks at one time and update the directory for the hyperlinks.

    Thanks

  2. #2
    amer is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    14
    Thanks to Suzan I was able to get this done. It was actually easy once I new what to do. As the JOE's say " knowing is half the battle"

    I selected my table.

    Selected my field.

    Changed the data type from hyperlink to text. ( this showed me all the actual hyperlinks)

    Then I used the replace command to change the directory in the hyperlinks from J:\ to R:\

    Finally I changed the data type from text back to hyperlink and it worked perfect.

    Here is a link to the actual thread that lead me to this.

    https://www.accessforums.net/forms/ho...rlink-282.html

    Hope this can help someone else down the line.....

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

Similar Threads

  1. Hyperlink in Report?
    By cadsvc in forum Reports
    Replies: 0
    Last Post: 05-11-2010, 07:27 PM
  2. Hyperlink Help
    By smikkelsen in forum Access
    Replies: 9
    Last Post: 03-12-2010, 11:28 AM
  3. have hyperlink use own name/text
    By airhud86 in forum Access
    Replies: 1
    Last Post: 12-16-2009, 09:35 AM
  4. Hyperlink problem
    By peterl in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 07:21 AM
  5. help with dynamic hyperlink to pdf
    By iresolver in forum Access
    Replies: 0
    Last Post: 12-24-2008, 01:21 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 - Senior Forums