Hyperlink on Form

[Nick Jax]

Hello,

I'm running Access 2003. I have a form which contains a Request Number
field. I want to insert an e-mail hyperlink and include a default subject.
Looks something like this:


mailto:[email protected]?subject=Request#

What I'd like to do is have the value from the Request Number Field included
in the subject line. Is there a way to reference the value inside of the
Request Number field so it appears on the subject line of the e-mail
hyperlink?

Thank you!

 

[kingston via AccessMonster.com]

Have you tried to concatenate the field value with the mail string?

stringHyp = "mailto:[email protected]?subject=Request " & Me.ReqNo
Application.FollowHyperlink stringHyp

 

[Nick Jax]

That didn't work...thanks though..

Have you tried to concatenate the field value with the mail string?

stringHyp = "mailto:[email protected]?subject=Request " & Me.ReqNo
Application.FollowHyperlink stringHyp

 

[kingston via AccessMonster.com]

What happened exactly? When I create a button with that code and click it, a
new mail message opens with the recipient and subject properly filled out.

That didn't work...thanks though..

Have you tried to concatenate the field value with the mail string?

[quoted text clipped - 15 lines]

 

[Nick Jax]

I think I'm putting the code you gave me in the wrong place!

This is what I did:
1 - Clicked INSERT
2 - Clicked HYPERLINK
3 - Selected e-mail address and in the subject line I put the code you gave
me.

I'm sure that's wrong. (obviously since it's not working).

Thanks again.

What happened exactly? When I create a button with that code and click it, a
new mail message opens with the recipient and subject properly filled out.

That didn't work...thanks though..

Have you tried to concatenate the field value with the mail string?

[quoted text clipped - 15 lines]

Thank you!

 

[kingston via AccessMonster.com]

The code should be inserted as part of an event procedure. Open the form in
design mode and select the control (e.g. textbox) that you want to activate
the hyperlink. Go to the control's properties window and Event tab. Go to
the OnClick event or whatever is appropriate and choose [Event Procedure].
Click the button at the end of the line with ... In the VB window, enter the
code I provided (replace Me.ReqNo with the correct control on your form).
When you open the form normally and click on the control (or perform whatever
event you deemed appropriate), the hyperlink should activate.

I think I'm putting the code you gave me in the wrong place!

This is what I did:
1 - Clicked INSERT
2 - Clicked HYPERLINK
3 - Selected e-mail address and in the subject line I put the code you gave
me.

I'm sure that's wrong. (obviously since it's not working).

Thanks again.

What happened exactly? When I create a button with that code and click it, a
new mail message opens with the recipient and subject properly filled out.

[quoted text clipped - 6 lines]

 

[Nick Jax]

Worked PERFECT! Thanks very much!!!

The code should be inserted as part of an event procedure. Open the form in
design mode and select the control (e.g. textbox) that you want to activate
the hyperlink. Go to the control's properties window and Event tab. Go to
the OnClick event or whatever is appropriate and choose [Event Procedure].
Click the button at the end of the line with ... In the VB window, enter the
code I provided (replace Me.ReqNo with the correct control on your form).
When you open the form normally and click on the control (or perform whatever
event you deemed appropriate), the hyperlink should activate.

I think I'm putting the code you gave me in the wrong place!

This is what I did:
1 - Clicked INSERT
2 - Clicked HYPERLINK
3 - Selected e-mail address and in the subject line I put the code you gave
me.

I'm sure that's wrong. (obviously since it's not working).

Thanks again.

What happened exactly? When I create a button with that code and click it, a
new mail message opens with the recipient and subject properly filled

out.
[quoted text clipped - 6 lines]

Thank you!