From Text format to Hyperlink format

[fabergoogle]

Hi all,

I have linked a .txt file from Access which contains web and email
addresses. They have a Hyperlink format but it doesn't work. I don't
know why.

What I've done is to build a query creating a table adding 2 new
fields through a formula ("web" and "email"). Then in the new table
I've changed the formats of those 2 new fields from Text to Hyperlink.
In this way the hyperlinks work.

I can't do this job every day. How can I make it automatic? How I can
change automatically the formats from text to hyperlink? Do I have to
use VBA or can I avoid it?

Thanks.
Fabrizio

 

[Jeanette Cunningham]

The hyperlink formats won't be recognized from a text file.
Set up a routine to append those 2 fields to a table, then see if it is
possible to base your form on a query joining the txt file with the table
( you will need a primary key to join on).
It might be easier to use a query to append the text file data to a table in
access with those 2 fields formatted as hyperlink type. Base your form on a
query from that table.
If you can create a suitable primary key and/or unique index, you can just
keep appending from the text file as needed without creating duplicates.

Jeanette Cunningham

 

[fabergoogle]

The hyperlink formats won't be recognized from a text file.
Set up a routine to append those 2 fields to a table, then see if it is
possible to base your form on a query joining the txt file with the table
( you will need a primary key to join on).
It might be easier to use a query to append the text file data to a table in
access with those 2 fields formatted as hyperlink type. Base your form on a
query from that table.
If you can create a suitable primary key and/or unique index, you can just
keep appending from the text file as needed without creating duplicates.

Jeanette Cunningham










- Show quoted text -

I tried the solution you suggested but it doesn't work because I get a
warning message saying there is a problem with the formats. I also
tried an update query but I had the same message.

 

[Jeanette Cunningham]

Try this instead:
just link to the txt file without doing anything about appending those 2
fields to any table.
Base your form on a query based on the txt file containing all the fields
you want, including the 2 hyperlink fields.
On the form or forms where you display the text containing the hyperlinks,
select the controls that display the hyperlinks and set their Is Hyperlink
property to Yes.
Property dialog | format tab | Is Hyperlink - towards bottom of list.

Jeanette Cunningham