creating hyperlink from predefined text string+number field

U

Uriel TK

Hello!
I am creating a small, simple table + form. every record
has:
1)a catalog number
2)a link to a local file
3)a text field for description
4)a yes/no box
5)autonumber which is the primary key.
I want to create a 6th field, which is a hyperlink to a
web site catalog, that opens the web browser when clicked
on. the hyperlink consists of a constant string which is
the address and query command of the site, followed by
the catalog number:
http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?
cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=7706722
All this string is constant except the last
number "7706722" which is the same as the catalog number
that i enter in the 1st field of the table. Please note
that the catalog number is an integer, and its length is
not fixed, ranging from 6 to 9 characters.
I could of course copy and paste the link for every
record, but i want automation since i have to input a lot
of records. I want this 6th field to be composed
automatically from the predefined string + the catalog
number i enter manually. A nice plus would be the ability
to change eventually the predefined string in case they
change address or engine or format.
How do i create such a field?

Thanks a lot!
Uriel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

create hyperlink from predefined string+number field 3
create hyperlink: "predefined text string+number field from the table" 1
Creating customized hyperlinks to a site 5
Copying a value from one record to the next if another field is sa 2
From Text format to Hyperlink format 3
Continue sequence from highest number in field 1
using VBA to populate a hyperlink field 2
Creating a field entry from multiple other fields. 1

Top