Access 2000 failing to activate "mailto: " hyperlink

[Tero Partanen]

Hello!

I'm writing about a rather peculiar problem I'm having with
Access2000.

I have a table in which I have created one hyperlink-type field. I
have given the field a default value which is an email-address. The
default value is (for example): "mailto:my****@here.com".

Access2000 correctly inserts that information into the field everytime
a new record is created to that table, but the problem is that the
email-address shown on the table is not recognized as an email-link by
Access. Ie. when I use the mouse to click on that hyperlink, nothing
happens.

The reason why this creates a problem is this: I'm using a short clip
of VB code to send automatic emails to the address stored in that
field, and the emailing code won't accept the data on that field,
unless it recognizes it as a "mailto: " email hyperlink.

What's even more weird is that with Access2002, which I originally
created the database with, the default value addition is correctly
done, ie. the new field can be clicked and an email client will open
-> the email sending code works.
But when I changed the field value recently with Access2000 the newly
created records displaying that email-field do absolutely nothing.
(yes, I have a table which has functional email fields and
non-functional, even though they appear to be exactly the same).

If anyone has any pointers to a solution, I'd be highly grateful :).

regards,
Tero P

[AppTrix]

Hi Tero,

I've run into that problem before - something silly for you to try but
it just might work.

In Access 2000, try putting pound signs around the contents of the
field. If you highlight a hyperlink field in Access 2002 and hit F2,
you'll see that it has a pound sign in the beginning and end of the
field even though it's not shown otherwise. Peculiar ...

From what I can remember (it was a couple years back after all), I had
to do something similar with Access 2000 - concatenating pound signs
in a query in order to make it a live hyperlink. I don't have an
elephant's memory, but give it a try - maybe it'll do the trick!

David
www.davidbase.com

[Tom van Stiphout]

On 5 Aug 2004 02:52:08 -0700, te****@paju.oulu.fi (Tero Partanen)
wrote:

Perhaps your email is not set up perfectly. Test it by running the:
mailto:my****@here.com
command in the Run box off of the Windows Start button.

-Tom.

Hello!

I'm writing about a rather peculiar problem I'm having with
Access2000.

I have a table in which I have created one hyperlink-type field. I
have given the field a default value which is an email-address. The
default value is (for example): "mailto:my****@here.com".

Access2000 correctly inserts that information into the field everytime
a new record is created to that table, but the problem is that the
email-address shown on the table is not recognized as an email-link by
Access. Ie. when I use the mouse to click on that hyperlink, nothing
happens.

The reason why this creates a problem is this: I'm using a short clip
of VB code to send automatic emails to the address stored in that
field, and the emailing code won't accept the data on that field,
unless it recognizes it as a "mailto: " email hyperlink.

What's even more weird is that with Access2002, which I originally
created the database with, the default value addition is correctly
done, ie. the new field can be clicked and an email client will open
-> the email sending code works.
But when I changed the field value recently with Access2000 the newly
created records displaying that email-field do absolutely nothing.
(yes, I have a table which has functional email fields and
non-functional, even though they appear to be exactly the same).

If anyone has any pointers to a solution, I'd be highly grateful :).

regards,
Tero P

[Tero Partanen]

Hi Tom,

No, the email address works just fine. Like I said, the table already
stores many addresses that are identical in appearance, but they do
work and trigger the e-mail client. Then the new records don't trigger
anything, even though the address itself is exactly the same.

cheers
Tero

Tom van Stiphout <no*************@cox.net> wrote in message news:<jk********************************@4ax.com>. ..

On 5 Aug 2004 02:52:08 -0700, te****@paju.oulu.fi (Tero Partanen)
wrote:

Perhaps your email is not set up perfectly. Test it by running the:
mailto:my****@here.com
command in the Run box off of the Windows Start button.

-Tom.

Hello!

I'm writing about a rather peculiar problem I'm having with
Access2000.

I have a table in which I have created one hyperlink-type field. I
have given the field a default value which is an email-address. The
default value is (for example): "mailto:my****@here.com".

Access2000 correctly inserts that information into the field everytime
a new record is created to that table, but the problem is that the
email-address shown on the table is not recognized as an email-link by
Access. Ie. when I use the mouse to click on that hyperlink, nothing
happens.

The reason why this creates a problem is this: I'm using a short clip
of VB code to send automatic emails to the address stored in that
field, and the emailing code won't accept the data on that field,
unless it recognizes it as a "mailto: " email hyperlink.

What's even more weird is that with Access2002, which I originally
created the database with, the default value addition is correctly
done, ie. the new field can be clicked and an email client will open
-> the email sending code works.
But when I changed the field value recently with Access2000 the newly
created records displaying that email-field do absolutely nothing.
(yes, I have a table which has functional email fields and
non-functional, even though they appear to be exactly the same).

If anyone has any pointers to a solution, I'd be highly grateful :).

regards,
Tero P

[david epsom dot com dot au]

"A Hyperlink field is made up of two parts: the displayed text,
and the actual address. Because the field type is Hyperlink, Access
assumes that the text that is entered will be a Web site and not
an e-mail address."

Have a look at this and see if it helps you:
http://support.microsoft.com/default...roduct=acc2000
HOW TO: Change the Values in a Hyperlink Field from an HTTP Address to a
MAILTO Address in Microsoft Access 2000
(david)

"Tero Partanen" <te****@paju.oulu.fi> wrote in message
news:18**************************@posting.google.c om...

Hello!

I'm writing about a rather peculiar problem I'm having with
Access2000.

I have a table in which I have created one hyperlink-type field. I
have given the field a default value which is an email-address. The
default value is (for example): "mailto:my****@here.com".

Access2000 correctly inserts that information into the field everytime
a new record is created to that table, but the problem is that the
email-address shown on the table is not recognized as an email-link by
Access. Ie. when I use the mouse to click on that hyperlink, nothing
happens.

The reason why this creates a problem is this: I'm using a short clip
of VB code to send automatic emails to the address stored in that
field, and the emailing code won't accept the data on that field,
unless it recognizes it as a "mailto: " email hyperlink.

What's even more weird is that with Access2002, which I originally
created the database with, the default value addition is correctly
done, ie. the new field can be clicked and an email client will open
-> the email sending code works.
But when I changed the field value recently with Access2000 the newly
created records displaying that email-field do absolutely nothing.
(yes, I have a table which has functional email fields and
non-functional, even though they appear to be exactly the same).

If anyone has any pointers to a solution, I'd be highly grateful :).

regards,
Tero P