Results 1 to 10 of 10
  1. #1
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360

    hyperlink no longer connects...

    in a current version of a MDB, clicking on a hyperlink in a table no longer connects to the internet (?!)



    I know for certain that it used to, so I opened an older version of the MDB (from a backup file), clicking does connect...
    so somewhere along the way, I must have done "something" to the current file (and too much time has passed along the way to revert to the former...)
    perplexed...

    thoughts and suggestions (with many thanks in advance)
    Mark

  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
    48,684
    Did you try replacing the hyperlink?
    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
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360
    not sure what you mean?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,684
    Test replacing the value in the hyperlink field for one record. Right click in the hyperlink field to open the dialog and browse/navigate to whatever it is the hyperlink should open. Does this hyperlink now work?
    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.

  5. #5
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360
    hmm...
    right-clicking to OPEN the link does nothing

    but more significantly,
    when I right-click and EDIT the link, I find that there is a "text to display", but the address is blank (at every record, and there are a lot of records! -UGH)
    ( I have a hunch on when / it happened; not at all sure why it happened; but more importantly, I need to now find an efficient way to fix it...)

    thoughts?

  6. #6
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360
    additional...

    all of the "Text To Display's" ARE ALWAYS the addresses, so it's a matter of opening each hyperlink in edit and copying the text to the address...

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,684
    The hyperlink should still work without display part. However, if the # delimiter is also gone (http://www.allenbrowne.com/casu-09.html), the hyperlink is corrupted.

    Can populate the field with an UPDATE or INSERT sql. So if you know what the parts are supposed to be (are they based on other values in table?), build the string and save in field.

    If the link is created from other fields in table, don't even need hyperlink field. Review: 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.

  8. #8
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360
    OK, makes sense

    so basically, I need to create a query that copies the Text To Display portion of the field entry into the Address
    do you know what a query like this would be? I'm only familiar with being able to replace the entire value of the field, hyperlinks are trickier (?) (and while I'm always willing to learn a new trick, a little direction would be a help - I'll also check out Allen Browne's link...)

    thnx !

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,684
    Okay, I had it backwards. The text to display is there but the address part is gone. Is the # also gone? Try:

    UPDATE tablename SET fieldname = fieldname & "#" & fieldname;
    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.

  10. #10
    markjkubicki's Avatar
    markjkubicki is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jul 2010
    Location
    Brooklyn Hts, NYC
    Posts
    360
    exactly! thanks

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

Similar Threads

  1. Replies: 4
    Last Post: 01-05-2013, 11:07 AM
  2. Replies: 4
    Last Post: 01-31-2011, 03:19 PM
  3. Replies: 6
    Last Post: 02-02-2010, 01:21 AM
  4. Tried and true programs no longer run
    By Seckert in forum Access
    Replies: 0
    Last Post: 04-07-2009, 01:45 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
  •  
Tech Forums: Microsoft Office Forums