Hello,
Please let me know if it’s possible to accomplish the following in Access 2010.
Table “tbl_Genes” contains a primary field: “GeneID”--Number, “GeneName”--Text and Memo fields: “Cosmic”, “UniProt”, “Google”and “PubMed”” that contain a unique Url for each record. Each gene name is unique as well.
I’ve created a small table “HyperlinkTypes” that consists of all four hyperlink types and a primary key.
On a continues form, for each record I would like to list all four hyperlink types: Cosmic, Uniprot, Google and PubMed inside a combo-box. When the user clicks on desired combo-box item, the corresponding website will launch. I’m not sure how to connect the combo-box to records in “tbl_Genes” table to make this work.
Please suggest how to link selection on the combo-box to urls listed in the tbl_Genes for each record.
Thank you very much,
Mila
Please let me know if it’s possible to accomplish the following in Access 2010.
Table “tbl_Genes” contains a primary field: “GeneID”--Number, “GeneName”--Text and Memo fields: “Cosmic”, “UniProt”, “Google”and “PubMed”” that contain a unique Url for each record. Each gene name is unique as well.
I’ve created a small table “HyperlinkTypes” that consists of all four hyperlink types and a primary key.
On a continues form, for each record I would like to list all four hyperlink types: Cosmic, Uniprot, Google and PubMed inside a combo-box. When the user clicks on desired combo-box item, the corresponding website will launch. I’m not sure how to connect the combo-box to records in “tbl_Genes” table to make this work.
Please suggest how to link selection on the combo-box to urls listed in the tbl_Genes for each record.
Thank you very much,
Mila