Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Change text to email hyperlink

Discussion in 'Information Technology' started by CoresysAdmin, Jul 28, 2006.

  1. CoresysAdmin

    CoresysAdmin
    Expand Collapse
    Guest

    We currently store email addresses in a text field which I wish to change to
    a hyperlink field. If I change the field type to hyperlink and use the
    following code on the form field this works perfectly for new addresses that
    are input.

    Private Sub Tut_Email2_AfterUpdate()
    Me![Tut_Email2] = Me![Tut_Email2].Text & "#" & "MailTo:" &
    Me![Tut_Email2].Text
    End Sub

    However, all of the existing data registeres as http://. Is their a way of
    updating all of the currently stored email addresses to change them to
    'mailto' rather than 'http://'. I have tried various update queries without
    success.
     
  2. Loading...

    Similar Threads Forum Date
    Christianity Has the text of the Bible changed over centuries? Interfaith Dialogues May 28, 2011
    Sikh News Sikh leaders want textbook changed Breaking News Jul 13, 2007
    Sikh News Sikh leaders want textbook changed -- again (The Sacramento Bee) Breaking News Jul 13, 2007
    Sikh News Bowing to Sikhs? Call, California Wants Textbook Change (New York Times) Breaking News Mar 12, 2007
    Can Sikhi Be Relevant In The Modern World As A Driver For Social Change? Blogs Feb 22, 2017

  3. OP
    Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    CoresysAdmin <CoresysAdmin@discussions.microsoft.com> wrote:

    >We currently store email addresses in a text field which I wish to change to
    >a hyperlink field.


    Why do you want to change the field to a hyperlink field?

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  4. OP
    CoresysAdmin

    CoresysAdmin
    Expand Collapse
    Guest

    In order that when we click on the email address it generates a new email
    with the address pre-filled. Currently we are having to cut and paste the
    email address in to the new email. If there is a better way of doing this I
    am open to suggestions.

    Cheers

    Michele

    "Tony Toews" wrote:

    > CoresysAdmin <CoresysAdmin@discussions.microsoft.com> wrote:
    >
    > >We currently store email addresses in a text field which I wish to change to
    > >a hyperlink field.

    >
    > Why do you want to change the field to a hyperlink field?
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >
     
  5. OP
    Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    CoresysAdmin <CoresysAdmin@discussions.microsoft.com> wrote:

    >In order that when we click on the email address it generates a new email
    >with the address pre-filled. Currently we are having to cut and paste the
    >email address in to the new email. If there is a better way of doing this I
    >am open to suggestions.


    You could use the SendObject command in a bit of code behind the form.
    Something like
    DoCmd.SendObject acSendNoObject, , , me!<name of field on form
    containing the email address>

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. OP
    CoresysAdmin

    CoresysAdmin
    Expand Collapse
    Guest

    Thanks for this - really helpful.

    "Tony Toews" wrote:

    > CoresysAdmin <CoresysAdmin@discussions.microsoft.com> wrote:
    >
    > >In order that when we click on the email address it generates a new email
    > >with the address pre-filled. Currently we are having to cut and paste the
    > >email address in to the new email. If there is a better way of doing this I
    > >am open to suggestions.

    >
    > You could use the SendObject command in a bit of code behind the form.
    > Something like
    > DoCmd.SendObject acSendNoObject, , , me!<name of field on form
    > containing the email address>
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page