Access XP and email hyperlinks detected as website links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SEFL - 19 Jun 2006 05:54 GMT

Hi there,

I've got a database I'm trying to fix up. I changed the email field
from a text field to a hyperlink field.

The problem is that every time I enter information into the email
field, it thinks that the email address is a webpage (the same thing
goes for the existing information). Since there's about 2500 records
containing email addresses, is there an easy way to convert them all to
email hyperlinks?

I can do an update query or something similar if there is such an
animal.

Thanks.

Adam
http://www.searchenginefriendlylayouts.com

Reply to this Message

Tom Wickerath - 19 Jun 2006 08:22 GMT

Hi Adam,

My recommendation is to change this field back to a text field. It will be a
lot easier to edit the e-mail address in the future, without a hyperlink
attempting to activate. Add a small command button next to this text field,
with an e-mail picture, to allow the user to click the button to send a
message. Name the command button cmdSendEmail. Add the following code for the
On Click event procedure:

Private Sub cmdSendEmail_Click()
On Error GoTo ProcError

DoCmd.SendObject To:=Nz(Me.txtEmail, "")

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure cmdSendEmail_Click..."
Resume ExitProc

End Sub

You can also provide other parameters, such as CC, BCC, Subject and text of
the message body. See the VBA help for SendObject.

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

> Hi there,
>
[quoted text clipped - 14 lines]
> Adam
> http://www.searchenginefriendlylayouts.com

Reply to this Message