default link to email

[Didge]

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! 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

 

[John Nurick]

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

 

[Didge]

Thanks John, I'll try that and see how I go.

 

[Didge]

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 :/

 

[John Nurick]

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?