Hyperlink Question

[Dick Bosworth]

I am designing a form which has an email address coming from the database
table. I would like to be able to click on a hyperlink and have it open a
mail client with the to address containing the email address.

P.S. I can get outlook to open, but don't know how to have the to address
filed in.

I would appreciate any help on this.

 

[Guest]

You can create a hyperlink field in the TABLE design by defining the data
type as hyperlink or in a form place the insertion point in the text Box that
accepts hyperlinks then click the Insert Hyperlink Button on theToolbar, The
Hyperlink Dialog box opens and you can insert the address at this point.
William McNulty
OfficeSpecialist/2003

 

[Guest]

Try adding this to your form's e-mail control property double-click event.
Change [strEMail1] to whatever name you have for your control.


On Error GoTo Err_strEMail_DblClick

Application.FollowHyperlink "Mailto:" & [strEMail1]


Exit_strEMail_DblClick:
Exit Sub

Err_strEMail_DblClick:
MsgBox Err.Description
Resume Exit_strEMail_DblClick

 

[Dick Bosworth]

More information:
I checked support.microsoft.com for how to solve this problem. They refer to
a toolbox control named "Bound Hyperlink" I have no such control in Access
2002?

 

[Guest]

Dick,

I use WinXP and Access2002 and all the information on 'Hyperlink' is there,
including how to add it in your table design. You can find the information by
searching for Hyperlink from the Help menu.

Have you tried either suggestion from Sunday88310 or from me? If you don't
like either suggestion then do a search for Hyperlink in the discussion group
for Access. This matter has been discussed many times before.

You can cut and paste the code from my former response, change the name to
your form control and you should be in business. I don't know what else to
suggest.