Search results

I got it to work but I have a performance related question if you don’t mind... Is it a bad idea to set up six sets of Subforms with sub-subforms on one unbound form? I need to display data side by side for six samples (six sets of forms) so the reviewer can look across instead of scowling...

Thanks, this is very helpful. Could you please clarify how to reference a textbox on subform frmSamples in a query that is used to populate record source for sub-subform frmCnvs? I've tried Me.Parent!ControlName and it didn't work. SELECT tbl_Sample1_CNVs.[chr:gene]...

Hello, I have an unbound form ”frmMain” with a subform “frmSamples”. The frmSamples has a bound sub-subform “frmCNVs”. On opening of the Main unbound form I would like to filter both the frmSamples” and also the “frmCNVs. I know how to filter the “frmSamples” but not sure how to refer to...

I'm closer but still can't figure out how to indicate the name of the tblVariants.Run_Name in the query, since that field is only present in tblVariants and I'm displaying records from tbl_Horizon200 that are not in tblVariants. The name of the Run is stored in a textbox on a form and only need...

Ok, but how should I change the query? I got the same results when I changed the Join type. Thanks

I’m trying to return values from table “tbl_Horizon200” that are not present in another larger table “tblVariants”. Instead of evaluating all of the records I would like to evaluate rows that meet additional criteria: tblVariants.Sample_Type = "HD200_QC"AND “tblVariants.Run_Name” matches the...

I'm not a contractor but really pressed for time. I'm going to create a fake navigation form with buttons that look like tabs and chage color conditionally. I will probably remake all the forms later. Thanks so much for your help.

Is it easier to pass "txtCurrentRun" value from frmVariants to frm_CNVs, since they are attached to the same navigation form, or not? Also, I was trying to pass "pass_current_run" value to a query that reference txtCurrentRun on frmVariants and this statement failed. This query is attached to...

I would like to apply a filter to NavigationSubform "frmVariants". The Navigation form is named "NavigationForm". How to correctly refence the form from another form "Search", outside the Navigation form? Before I attached "frmVariants" to "NavigationForm" my code was...

Sorry one more quick question if you don't mind... If I wanted to pass the same value to another subform of the "Navigation Form" frmCNV. It also has a textbox named txtCurrentRun and I would like to pass that value to that form also. How do I refence it correctly? Do I have to browse to it or...

Thank you!:)

yes,it is a name of a text box, however, temvar doesn't work for some reason. I've tried to declare a global variable in main module and use it to pass the value to the control. Global pass_run_name As String pass_run_name = Forms!tblRuns!Run_Name Debug.Print pass_run_name 'prints out the...

I get an error "tempvar can only store data, it can't strore objects" at line TempVars!RunName = Forms!frmRuns!Run_Name

Hello, I've created a Navigation Form with two tabs. It appears that Access renames all forms that are dropped in a tab as "NavigationSubform". I would like the Navigation Form to Open on a tab where "frmVariants" was dropped, when a textbox located on frmRuns is clicked. frmRuns is not a...

I think I got it: CN: IIf(([S1_Raw_CN]-2*(1-[S1_Cellularity]))/[S1_Raw_CN]<0,0,([S1_Raw_CN]-2*(1-[S1_Cellularity]))/[S1_Raw_CN]) Thanks

this query should work but it doesn't return anything. SELECT tbl_CNVs.[Chr:Pos:Gene], tbl_CNVs.Run_Name, tbl_CNVs.Sample1_Name, tbl_CNVs.S1_Sample_Type, tbl_CNVs.S1_Cellularity, tbl_CNVs.[S1_5%_CI], tbl_CNVs.[S1_95%_CI], tbl_CNVs.S1_Raw_CN, ([S1_Raw_CN]-2*(1-[S1_Cellularity]))/[S1_Raw_CN] AS...

Here is the SQL statement that returns nothing: SELECT tbl_CNVs.[Chr:Pos:Gene], tbl_CNVs.Run_Name, tbl_CNVs.Sample1_Name, tbl_CNVs.S1_Sample_Type, tbl_CNVs.S1_Cellularity, tbl_CNVs.[S1_5%_CI], tbl_CNVs.[S1_95%_CI], tbl_CNVs.S1_Raw_CN, ([S1_Raw_CN]-2*(1-[S1_Cellularity]))/[S1_Raw_CN] AS CN FROM...

Could you please show examples? Thanks

I would like to use the following formula in a calculated field in a query: CorrCN: Max(0,(([S1_Raw-CN]-2*(1-[S1_Cellularity]))/[S1_Cellularity]))) I need to use Max function to return 0 if the formula returns a negative value. When I type this formula into a field, I get the following error...

Ok, I solved it. I need to requery after the textbox is clicked on frmRuns and not on Form Load of frmVariants. Forms!frmVariants!lstTumorType.Requery