create hyperlink from predefined string+number field

[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.

 

[Guest]

You use the BeforeUpdate events to trap the value, check & if necessary add
the prefix. (The prefix is
'http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=Abstract&list_uids=')
Terry

 

[Gargamil]

Alternatively have the database generate the link dynamically each time. I
always work under the premise of not storing anything I can create from
scratch when needed. So you'd have a hyperlink field reading
"http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=A
bstract&list_uids=" & str([Catalog Number]) <---- never sure how the
software will add integers, better to force the issue

g

 

[Guest]

This is fine & I agree with the sentiment but use Trim(Str([Catalog Number]))
otherwise an additional space will be generated and throw things out.
Terry

Alternatively have the database generate the link dynamically each time. I
always work under the premise of not storing anything I can create from
scratch when needed. So you'd have a hyperlink field reading
"http://www.ncbi.nlm.nih.gov/entrez/query.fcgi?cmd=Retrieve&db=pubmed&dopt=A
bstract&list_uids=" & str([Catalog Number]) <---- never sure how the
software will add integers, better to force the issue

g

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.