Search results

Hello, There are two date fields txtStartDate and txtEndDate on a form that filters a sub-form. This this the query behind the sub-form: PARAMETERS [Forms]![frm_search_comments]![txt_gene] Text ( 255 ), [Forms]![frm_search_comments]![txt_variant] Text ( 255 )...

I will get rid of the "All" choice from the combobox thus eliminating the problem. This will save a lot of time. thanks

it will be very difficult to get to 1MB. I will try.

It looks like it executes but still the combobox is blank. thanks I've tried just about anything but nothing works.

Sorry one more follow-up question: One of the forms has a drop-downs with (All) choice that isn’t present in a combobox of the second form that I’m opening. I’ve included the following code in the Form_Open event of the second form, however, the combobox fails to populate with the first item if...

Great! Thanks you.

The db is way too large. It will take me a long time to reduce it to 1MB.

I've tried the following but it failed as well: Dim index_val As Integer If Not IsNull(Me.OpenArgs) Then Debug.Print Me.OpenArgs index_val = val(Me.OpenArgs) Me!frm_sample_cnv1.Form!cmb_samples = Me!frm_sample_cnv1.Form!cmb_samples.ItemData(idex_val) End If

Doesn't work either. i get "Compile error: argument not option" Thanks

Hello, I have two forms, each has a combo-box “cb_samples” with the identical query. After a user selects an item from combobox on FormA and pressed a button “openFormB”, I would like FormA to close and FormB to open with the combobox showing the same item that was selected on FormA. Here is...

Hi Steve, I had problem login in to this forum for a couple of days. Thanks again for great code.

Hi Steve, I really like the function that you've wrote and the way you call the function from each field click event. I had it set up as the frmGeneSample earlier but they want a grid so they can click and import multiple samples. I've modified the cross-tab query so the sample names are in...

The genes can change. If you can find a solution that would be fantastic. The maximum number of samples is 6 for now but this could change as well in the future. Right now we are working with 20 genes. Thanks, Mila

Thanks Steve, The only problem is see is how to bind the sample names that will be different each time to controls on the form. The form is bound to specific fields on the query (sample names). Perhaps it's better to change the query so the sample names are in column A and genes go across? The...

Hi Steve, Please see the attached db. The link-outs are to an app called IGV that needs to be downloaded so they will not work but the syntax is this: Application.FollowHyperlink "http://localhost:60151/load?file=file:///L:/" & run_name & "/bam/" & sample_name & "_region_" & gene &...

Hi Steve, On the form I would like to display what I've attached on the example, however, the query should have "start" and "end" fields available if posible? My goal is to build linkouts using these fields. So when the user click on a specific gene a related webpage will open. The sample_name...

Hello, I have two unrelated table (screenshot is attached) I would like to combine them into a query that can be used as row-source for a continuous form(example is also attached). I've tried a Union query and Crosstab query but so far my attempts were unsuccessful. Could you please...

that is exactly right! thanks

I've used the following code behind a button to close a form and it worked great. I made changes to the design and made the form a subform and the code is not working. Please suggest how to close the main form from a button on the subform. On Error GoTo HandleError DoCmd.RunCommand...

I’m trying to fill a combobox with distinct samples names. Each sample name repeats in tbl_Variant_qry and contains “IonXpress_number”. For example: SU-15-41899-select_IonXpress_003 and MD-15-24019-SSIV_IonXpress_004. I would like to sort samples by “IonXpress_number” segment in ascending...