default link to email

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm fairly new to access... crash course victim ;)... Is there a way, in
form design view, to make a hyperlink that opens up the email address you
click on? I've done the hyperlink but from what I can see, it's asking me to
go through and create a link for EVERY email address in order for them to
work. That's just not viable in a db with 1100 records! :p So is there some
expression that just says 'whatever email address I click on, open a new
email message in outlook, and send that email address to its address field',
sorta thing? Simple terms please, I'm not really offey with all the jargon
yet :)
 
Hi Didge,

Here's one way:

1) Use a Text field, not a Hyperlink one, in the table.

2) On the form, have a textbox bound to the text field.

3) In the textbox's DoubleClick event procedure, use

Application.FollowHyperlink "mailto:" & Me.ActiveControl.Value
 
Hi John

Well.... checked the design of the table, it's a text field.... checked the
design of the form, it's a text box.... pasted that code you gave me into the
event procedure (that's the VB window, isn't it?) and it seems still to be
having problems. When I tried it, it still would only open some and not
others... hmmm :/
 
Hi Didge,

Please post the code you've actually used, and samples of the addresses
that do and do not "open".

You say "open some and not others". Exactly what happens or doesn't
happen?
 
Back
Top