J
John P via AccessMonster.com
I have a form, having an e-mail field linked to a table/field type that is,
“hyperlink". I used the following code in the, “Onclick” behind the field
properties:
Private Sub email_Click()
On Error GoTo ErrLine
DoCmd.SendObject acSendNoObject, , , email, , , , , True
ExitLine:
Exit Sub
ErrLine:
Resume ExitLine
End Sub
Also, for each field in both forms under Properties/Format, “Is Hyperlink” I
have a, “Yes” indicated.
Once completed, the user can type an e-mail address. After you type in the
address, you can then click on the hyperlinked field to send e-mail.
I have two problems:
When I send e-mail from the form, the following appears on the “To:” line:
[email protected]#http://[email protected]#
After I close the e-mail form; I then get linked to my hotmail.com main page.
The second problem is in the editing of the field. If I have to edit/change
the e-mail address in this field; I have to tab into it and retype the whole
e-mail address. Otherwise, it links (opens) the e-mail form.
John
“hyperlink". I used the following code in the, “Onclick” behind the field
properties:
Private Sub email_Click()
On Error GoTo ErrLine
DoCmd.SendObject acSendNoObject, , , email, , , , , True
ExitLine:
Exit Sub
ErrLine:
Resume ExitLine
End Sub
Also, for each field in both forms under Properties/Format, “Is Hyperlink” I
have a, “Yes” indicated.
Once completed, the user can type an e-mail address. After you type in the
address, you can then click on the hyperlinked field to send e-mail.
I have two problems:
When I send e-mail from the form, the following appears on the “To:” line:
[email protected]#http://[email protected]#
After I close the e-mail form; I then get linked to my hotmail.com main page.
The second problem is in the editing of the field. If I have to edit/change
the e-mail address in this field; I have to tab into it and retype the whole
e-mail address. Otherwise, it links (opens) the e-mail form.
John