Search results

Hello, I get an error message " includes fields that are not selected by the query" in the following union query. Could someone suggests how to fix it. thanks SELECT tbl_Variant_qry.sample_name, tbl_Variant_qry.tumor_type, tbl_Variant_qry.gene_panel, tbl_Variant_qry.run_name...

the tables are not related

I need to construct where clause using vba. I would like to retrieve records from a table that have a variant_id that contains specific strings that are retrieved from another table. Let's say the variant_id is "EGFR_ALK_DS52", the combination of RS("gene") & "_" & RS("aa_change") will return...

Please suggest the proper punctuation for instr formula in SQL vba statement this is not correct: Do While Not RS.EOF criteria = criteria & InStr([variant_id], RS("gene") & "_" & RS("aa_change")) > 0) & " OR " RS.MoveNext thanks, Mila

Hello, I'm trying to create a batch file that copies the front end to the desk top. Could someone please explain what the line below references? Does it reference the back end? in I'm assuming that \\MySharePath\MyNetworkFolder\Admin\MyDivision\MyApplication\MyApplication_JohnGault.accdb...

I had a stroke of genius and figured out a solution. :)

You are correct the text box was not named "cellularity". I've changed the control name to txt_cellularity and adjusted all the formulas, but again I get prompted on the closing of the form. Now I'm asked for the value for the "txt_cullularity" text box. Something else is wrong? I'm attaching...

That's a good idea.

Could you please suggest how to execute the bat file and also input any key that is required by the bat file? Also, where should the code fire from? Thank you?

Hello, The back end of my Access database will be located on a shared drive L:. I execute a bat file to mount the L: drive each time I log into my PC. Here is what the bat file says: mount -o fileaccess=775 10.20.219.75:/data L: pause end Is it possible to map this drive via Access's...

Please see the attached. I took out most of the forms and queries to get it down to 2MB. Please open "frm_combined_CNVs_with_Comments" and then close to reproduce the error. Thank you very much,

Hello, I have a main form with sub-form and sub-sub-form. One of the calculated fields that serves as the row source for the sub-sub-form is dependent on a textbox on the sub-form, as reference in the formula below: CorrFifty1...

I've used If IsDate(Me.txtStartDate) = True Then and also Me.cmb_project_name = Null to clear the combobox. Thanks

The problem was that I wasn't assigning a value to one of the primary key fields, therefore, that record wasn't visible on the form. Thank you very much to JHB for helping to diagnose the issue.

I've tried this: With Me.frm_Fusions.Form .Visible = (.RecordsetClone.RecordCount > 0) End With and get the same error message.

"frm_Fusions" is the name of the control and also is the Source Object. The linked field is named sample_id.

I'm confused... please clarify how to reference the subform from the main form correctly. What should I change my code to? Thanks

I'm referencing the subform from a control event (AfterUpdate) of the main form, therefore, I don't think it's going to work. I'm trying to determine if the record source is empty and if it is I want to hide the subform form. This code was working at some point but now throwing error messages...

Yes, It stops here With Me![frm_Fusions].Form .Visible = (.RecordsetClone.RecordCount > 0) End With and tells me it doesn't recognize the subform "frm_Fusions".

@Rural guy. I've just imported the whole database into a new file. Unfortunately, I get the same error messages as before. Thanks