Results 1 to 7 of 7
  1. #1
    StuartR is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Location
    Scotland
    Posts
    46

    Why has email hyperlink stopped working ?

    A wee bit advice needed ...



    My database table has a number of hyperlink fields to store email addresses. The table is accessed from various forms and reports, but when you click on the hyperlink in any of these locations, including the main table, then nothing is happening. This was tested as I was developing the system, and I am sure the default email programme (microsoft outlook) previously opened up with the recipients email address already entered.

    Has there been an update to outlook that is affecting this, or have I lost a setting of some sort in Access.

    I am using Access 2016.

    Any clues would be appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    what does the hyperlink say? mailto:?

  3. #3
    StuartR is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Location
    Scotland
    Posts
    46
    Ranman,

    They are simply hyperlink fields as set in the data type on the property sheet in the table design view. Where would one stipulate "mailto:" ???

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    How are you inputting hyperlinks into field - with the Insert Hyperlink dialog?

    Type the email address into the Address box and Access automatically prefixes with mailto:.
    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
    StuartR is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Location
    Scotland
    Posts
    46
    Thanks June ~ a wee bit progress here, but still a mystery to be solved.

    It transpires that if you add a new record, the email address works fine, as it did originally (which was with test data all entered individually). The issue seems to be with records that we have imported from a previous table, where the field was simply a text field and we were importing it into a hyperlink field. The data appears like a hyperlink, underlined etc, but does not act as one ~ as previously mentioned, clicking on it does nothing while it should open up the default email programme which it is doing with new records.

    So the issue now is how we convert the existing imported email addresses into "real" hyperlink data. We have 213 of them so re-entering does not appeal. Any suggestions ???

    Cheers

    Stuart

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Hyperlink fields consist of two (or three) parts. If you import a text field into a hyperlink field it will not work as it only contains one of the parts.
    See this link http://allenbrowne.com/casu-09.html
    Many developers avoid hyperlink fields as they can be difficult to use

    You need to create or find a function to complete the missing section in each record
    Or I would recommend changing back t a text field and using mail to.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Can use an UPDATE query to correct the existing records.

    UPDATE tablename SET fieldname = "mailto:" & [fieldname] WHERE fieldname NOT LIKE "mailto:*";

    or

    UPDATE tablename SET fieldname = "mailto:" & Left([fieldname], InStr([fieldname], "@")) & "#mailto:" & [fieldname] & "#" WHERE fieldname NOT LIKE "mailto:*";

    I tried to construct the second UPDATE to run in VBA immediate window with CurrentDb.Execute and kept getting 'data mismatch' errors. Works in Access query object.
    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. Query stopped working
    By AndyC121 in forum Queries
    Replies: 3
    Last Post: 09-30-2015, 12:34 PM
  2. Subforms stopped working
    By Paul H in forum Forms
    Replies: 7
    Last Post: 06-17-2014, 09:50 AM
  3. Replies: 22
    Last Post: 04-24-2014, 01:56 PM
  4. Access has stopped working
    By mrkaye in forum Access
    Replies: 0
    Last Post: 05-22-2012, 04:09 PM
  5. All Buttons Stopped Working and...
    By rhoridge in forum Programming
    Replies: 1
    Last Post: 12-02-2010, 11:25 PM

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