Re: create hyperlink from predefined string+number field

From: Gargamil (wooble_at_tpgi.com.au)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 23:43:13 +1000

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

"Uriel TK" <anonymous@discussions.microsoft.com> wrote in message
news:657501c4936e$045ebde0$a501280a@phx.gbl...
> 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)
  • 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: create hyperlink from predefined string+number field
    ... (The prefix is ... "Uriel TK" wrote: ... > web site catalog, that opens the web browser when clicked ... the hyperlink consists of a constant string which is ...
    (microsoft.public.access.formscoding)
  • Re: Searching for 2004/3/EC (for example)
    ... I don't understand your date convention, or is it even a date convention. ... > Indexing Service seems to break strings on forward slashes and then ... > and it is this that converts both the catalog entry and the search ... > string to 2004/anything/EC when using 0-9 as the middle section. ...
    (microsoft.public.inetserver.indexserver)