Results 1 to 2 of 2
  1. #1
    Suzan is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2006
    Posts
    13

    How to change http:// to mailto: in hyperlink

    I did it!!! I cant believe it!!!!
    I was trying to fix the problem of the hyperlink issue, changing it from http:// to mailto: if you want to send email by outlook do the following:

    1. Temporarily change the datatype of your field to TEXT
    2. Run the following update statement (changing the table name and field
    name appropriately):



    UPDATE HyperLinks SET HyperLinks.EmailAddress = "#Mailto:" &
    Mid([EmailAddress],9);

    3. Change the datatype of y our field back to Hyperlink.


    I did it and worked!!!
    Hope this can help anyone stuck in this problem!!!

    Best Regards,

    Suzan

  2. #2
    amer is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2010
    Posts
    14
    YESSSSSS

    Thanks so much. I've been trying to change the directory from F:\ to R:\ on my image hyperlinks for weeks. This did it.

    I changed the field type to text. Used the replace command and then turned the field type back to hyperlink.

    Thanks again...

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

Similar Threads

  1. Change Date Into Number
    By greenbag in forum Queries
    Replies: 0
    Last Post: 11-14-2008, 04:43 PM
  2. Forms: Not immediate change of database
    By firlanu in forum Forms
    Replies: 5
    Last Post: 08-11-2008, 12:04 PM
  3. Change of label size
    By Zoroxeus in forum Programming
    Replies: 0
    Last Post: 06-11-2007, 08:18 AM
  4. Replies: 10
    Last Post: 11-13-2006, 02:07 AM
  5. Change the colour of a form background
    By r_e_v_a_n_s in forum Forms
    Replies: 0
    Last Post: 11-15-2005, 03:39 AM

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