RE: create hyperlink from predefined string+number field

From: Terry (Terry_at_discussions.microsoft.com)
Date: 09/05/04 

Date: Sun, 5 Sep 2004 16:43:03 -0700

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

"Uriel TK" wrote:

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

Relevant Pages

  • Re: resize JTable
    ... >> i suspect the best way is to compare length then alpha, ... Callback for sort, as a catalog number. ... > public final int compare(String a, ... > // for speed could do tidyKey ahead of time, ...
    (comp.lang.java.programmer)
  • Re: Generic delete
    ... this is what I use to mass-delete datasets from a catalog: ... ARG DSNPREFIX ... SAY A DATASET NAME PREFIX IS REQUIRED. ... For IBM-MAIN subscribe / signoff / archive access instructions, ...
    (bit.listserv.ibm-main)
  • Semantic of getTables
    ... java.sql.DatabaseMetaData#getTables(String, String, String, String) ... catalog - a catalog name; must match the catalog name as it is stored ... schemaPattern - a schema name pattern; must match the schema name as ... it is stored in the database; "" retrieves those without a schema; ...
    (comp.lang.java.databases)
  • Re: How to know columns names in Derby database table
    ... ResultSet getColumns(String catalog, ... String tableNamePattern, ... TABLE_SCHEM String => table schema ... reference attribute ...
    (comp.lang.java.databases)
  • Re: Speed up ado updates
    ... Select FilePath from catalog WHERE ParentDirectory Is Null ... puts sql_update ... I'd make data_source and prefix constants (capital letters, ... can find out yourself using Benchmark class) ...
    (comp.lang.ruby)