Search results

Hello, I would like to filter [gene_panel] fields by [gene] field of the same table. The [gene] field consists on a single gene name (e.g KRAS) and the [gene_panel] field consists of a comma delimited string of genes (KRAS,NRAS,KIT). I would like a query to return records where [gene_panel]...

This limits my options. Is there anything that can be done to allow edits of some of the fields on a form that is bound to such query? Perhaps, having two forms side by side one static and one updatable? Thanks

I just realized that I will not be able to edit any records on the form with the “final query” as the row source. I will need to make changes to data displayed on the form. Is there anything I can do to more it editable? Thanks and sorry to bother you again. Mila

A message pops up when I click on any fields of a continuous form "The recordset is not updatable". Please suggest how to diagnose this problem. Thanks, Mila

Ok, I solved it. I used two queries: First: SELECT tbl_failed_amplicons.sample_name, tbl_failed_amplicons.run_name, tbl_failed_amplicons.sample_id, [gene] & " " & [exon] & " " & [depth] AS Exp FROM tbl_failed_amplicons; Second: SELECT Distinct...

I’ve tried the other function that uses ADOBD connection but got an error message on ADODB.Connection that it couldn’t find the connection. Allen Browne’s function produces an output, however, I’m not sure how to modify the function to get the desired output. Here is the query that executed...

I've found a post that uses ADODB.Connection and not DAO.Recordset for this, which is better? Thanks, Mila http://stackoverflow.com/questions/5174362/microsoft-access-condense-multiple-lines-in-a-table/5174843#5174843

The described function only takes in one field as the parameter. I would like to concatenate three fields for related records. Can this be done in Access? Thanks

Hello, I would like to concatenate multiple related records from one table and display them on a form (please see the attached example). Is there a way to do this without creating another table? If so, how? Thanks, Mila

Ok, Me.lst_fusions.ItemData(1).Column(0) doesn't work but if i bind column 2 then I can just use ctl.ItemData(Itm) to get values in from the second column. Mila

Accually, I get Error 424 Object required with For Each Itm In Me.lst_fusions.ItemsSelected Debug.Print Me.lst_fusions.ItemData(Itm).Column(0) It's not recognizing the data in the listbox?

Hello, I would like to build criteria from selected items of a multicolumn list box. How do I specify the column number that I will use to build the criteria? I only need values from column 1. Thanks Set ctl = Me![lst_fusions] For Each Itm In ctl.ItemsSelected If Len(Criteria) = 0...

Thank you, this is exactly what I was looking for.

Yes, but I also need to include other fields from tbl_Variants as well. Please see frm_Variants for clarification. You are suggesting on using a subform that would be filtered as the user clicks on each record on the main Variant form, correct? Thanks

please see attached query results for id 792. Alsi, I'm still confused about how to to display these query results of from. I've tried Dlookup and it failed. Thanks

@sneuburg Perhaps your query can be used to lookup both values to display on the form? I've added this lookup to the query that returns all variants and populates the form but something is wrong with the expression. Expr1: DLookUp("qry_variant","qry_final_query","[tumor_type]=" &...

Right, the query should return every single record in Variant table. thanks

:) Ok, sorry. On “frmVariants” form, field “#of Variants per Tumor Type” should display the number of occurrences of variants [aa_change] in “tumor type”. For example: the first tumor type is LUNG and variant is V600E. This variant appears in 3 Lung cases, therefore, it should show 3. The...

Please the attached example db for clarification. Thanks so much for your help. Mila p.s. Mila is not a boy's name.

I would like to display the count of each “aa_change” in each “tumor_type” in one field and the count of distinct “samples_ids” in each “tumor_type” in another field on a continuous form. Instead of a summary table I would like incorporate these statistics with each record in “Variant” table...