Search results

The Me.Text216 line is highlighted yellow and there is a control source in it, but no formula. Thanks.

If I take out: Me.Text216 = "It is recommended that this individual and any first degree relative receive continued clinical evaluation and follow-up. Genetic counseling is recommended for this individual and their family. For assistance in locating nearby genetic counseling services please...

In the After Update: Private Sub cboResult_AfterUpdate() If Me.cboResult = "Negative" Then Me.txtResult = "Negative" Me.Text216 = "It is recommended that this individual and any first degree relative receive continued clinical evaluation and follow-up. Genetic counseling is recommended for...

I have a combo-box (Results) that has a drop-down in which either Negative or Positive can be selected. If Negative is selected can a text-box (Data) be populated with the text "nothing detected", but if Positive is selected then Data remains empty...

In an Access 2010 query is it possible to set a criteria on a field (Results), that If it is "Negative" then another field (Variants) has the text "None Detected". Or is it easier to do that in the Variants field? Thank you.

Is it possible to have a textbox on a form (Group) be auto-filled with text based on a combo-box (Name) selection? If the combo-box is "No" then Group is "Green", If combo-box is "Yes" the Group is Yellow. Thank you.

I can see the data in the mail merge that the form populates but not in the table the form is linked to.

I have data that is: 12, 112888212, PTPN11, , c.[228G>C]+[=], 76E>DE,HGMD accession: CM013419; Disease causing mutation,Tartaglia (2001) Nat Genet 29: 465 PubMed: 11704759, Edouard (2010) Mol Cell Biol 30: 2498 PubMed: 20308328 c.228G>C, PTPN11 exon 3, , , , ,, c.3310_3312delGAA; p.1104delE...

I can not seem to paste text into a text box on an access 2010 form. I am however able to paste the text in a word document. Thanks.

Is it possible in Access 2010 to create a textbox (Team) and a textbox (Captain) on a form that auto-fills depending on a key word in the (Data) textbox? The color is the key word. For Example, if in Data: The color is Blue Team auto-fills with Team One Captain auto-fills with Chris The...

=IIf([Results]="Negative","No Variants Detected","") Eventhough the Results field Combobox is Negative the text does not fill in the textbox. Thanks.

This seems correct, but it is not working. =IIf([Results]="Negative","No Variants Detected") Thank you.

Thank you.

I apologize for the confusion. I have a combobox (Results) on a form (Test) and that combobox can have two values (either positive or negative). If negative is selected I have setup a query that will automatically fill in some generic text. If the Result is positive however I would like to...

So I put the code on the form (Test) in the Data (textbox), combobox (Result): If [Result] >= 0 then [Data] 'Create a query Show End If The Show query: Show: IIf [(Result)] >=0 then "[(Data)]" will simply selecting the show box only show this statement if true? Thanks.

Is it possible in access 2010 to create a a query that only shows a text box if a combo box criteria is met? Example: On a form there is a combobox (Result) that can either be negative or positive. If the value is Negative then a query is already setup that populates a mailmerge with some...

When I put this into the query and try to run it: "Enter Parameter Value" results. Also, the mail merge document that it was linked to does not work unless that code is removed. Thanks. Test: IIf([Results]="Positive",[Forms]![Data]![Text207],"")

Thank you for your help... I can not access the help file for some reason and need to re-install Access.

form is Data, Results is the criteria, and Text207 is the textbox: test: [Forms]![Data]![Text207] but I'm not sure how to use a IIf() criteria. Thank you very much.

So then if the form is Data, Results is the criteria, and Text207 is the textbox: Test: IIf([Results]="Positive" “Data.Text207”) is the correct syntax? Thank you.