Access data field

[Guest]

I created a field in access form to enter an email address. How can I make
it automatically when I double click the email address I entered on the form
field the email address goes to Microsoft outlook email address form.

 

[Jeff Boyce]

Rose

One approach would be to add some code to the DoubleClick event. In that
code, you'd add something like:

"mailto:"

on in front of the email address in your control on the form, then follow
the hyperlink.

The code could be as simple as:

Application.FollowHyperlink "mailto:" & Me![YourControl].Text

(use your control's name).

Regards

Jeff Boyce
<Office/Access MVP>

 

[Guest]

Hi Jeff,
I have one more question. What is my control's name?

Thanks

Rose

One approach would be to add some code to the DoubleClick event. In that
code, you'd add something like:

"mailto:"

on in front of the email address in your control on the form, then follow
the hyperlink.

The code could be as simple as:

Application.FollowHyperlink "mailto:" & Me![YourControl].Text

(use your control's name).

Regards

Jeff Boyce
<Office/Access MVP>

I created a field in access form to enter an email address. How can I make
it automatically when I double click the email address I entered on the
form
field the email address goes to Microsoft outlook email address form.

 

[Larry Linson]

Hi Jeff,
I have one more question. What is my control's name?

The Control is the box (of whatever type) on the Form, in which data is
displayed. Right-click the Control and Choose properties, and you'll see the
name of the Control as the first line in the Other tab of the Property
Sheet.

Can I suggest, at this level of question, that you (1) either purchase a
book aimed at novice users (Microsoft Access Step by Step, from Microsoft
Press, is a good one, and there are many others including Microsoft Access
Inside Out by John Viescas, also from Microsoft Press) and a little study to
learn the very basics or (2) you visit Office Online at
http://office.microsoft.com and look in the list that follows "Home" on the
left side of the page, follow the "Training" link and go through some,
better yet, all, of the very good online training courses for Access.

Larry Linson
Microsoft Access MVP

 

[Guest]

it works thanks for your help...

rose

The Control is the box (of whatever type) on the Form, in which data is
displayed. Right-click the Control and Choose properties, and you'll see the
name of the Control as the first line in the Other tab of the Property
Sheet.

Can I suggest, at this level of question, that you (1) either purchase a
book aimed at novice users (Microsoft Access Step by Step, from Microsoft
Press, is a good one, and there are many others including Microsoft Access
Inside Out by John Viescas, also from Microsoft Press) and a little study to
learn the very basics or (2) you visit Office Online at
http://office.microsoft.com and look in the list that follows "Home" on the
left side of the page, follow the "Training" link and go through some,
better yet, all, of the very good online training courses for Access.

Larry Linson
Microsoft Access MVP