Search results

I have table (tblTest): Kit Lot InUse Amp 123 Yes Amp 456 No On a form I have: Kit Lot What I would like to do is create an AfterUpdate select statement on the form that pulls the Kit in the table where Inuse = Yes: Private Sub Text245_AfterUpdate() If Me.Text225 = "Test" Or Me.Text225 =...

[tblTest].[Date] DESC, [tblTest].[Inuse] Whenever the Inuse is checked that is what populates the form. I need the records that already had values in them to remain unchanged. Thanks.

DMax("Kit", "tblTest", "Inuse = -1") in the table I set Inuse to decending, is this not correct? Thank you.

=DLookUp("[Kit]","tblExtraction","[Inuse] = -1") The above code pulls the lot # of a kit from a table Extraction where the field is checked in-use. If on the 11 record the in-use changes how can the previous 10 records remain unchanged? For example, Record 1-10 Kit 1234 is in-use and so is...

The holidays need to be included in the calculation as well. Thanks.

Me.Text225 = Me.Original + 30 Can this code be based on a work week (Monday though Friday) instead of 7 days? Thank you.

I have a date field (original) in a form (All). I am trying to add 30 days to whatever is entered in the original field: Private Sub Text225_AfterUpdate() Me.Original + 30 End Sub This doesn't seem right though. Thank you.

Interpretation: IIf([Results]="Not Detected","Sequence analysis reveals no genetic variant in " & [VUS] & " in this sample, IIf([Results)="Detected","Sequence analysis reveals a genetic variant in " & [VUS] & " in this sample.") Is this the correct syntax for two IIf statements? Thanks.

The lot #'s in tblQubit are unique. tblQubit Lot In-use 123 check 456 no check 789 no check =DLookUp("[Kit]","tblQubit","[Inuse] = -1") pulls the lot # with the check into a form automatically so the user does not have to enter it. The problem is, when a new lot is in-use that...

tblQubit Lot In-Use 1234 yes 5678 no 9 10 11 12 no I use the code below to pull the Lot from the tblQubit where in-use is yes. =DLookUp("[Kit]","tblQubit","[Inuse] = -1") This works fine until I change the Lot and another is In-use, then all that populates...

I have a tblQubit: 1234 5678 9876 Is it possible to use DLookup to pull the Lot in-use: =DLookUp("[Kit]","tblQubit","[Inuse] = -1") But when that lot changes it only applies to new records and the previous lot remain unchanged? So if records 1,2,3,4 used lot: 1234 Record 5,6,7,8 lot: 5678...

Hello, What is the correct syntax for an after update: If Me.Results = "Detected" And Me.Parent = "Mother" Then Me.Text 233 = "....." The Me.Results and Me.Parent are the combo-box and the Me.Text233 is the textbox where the ..... fills. Thanks.

What is the correct syntax of and OR statement in a query? IIf([Color)="Blue or Green","group is 1". Thank you.

I have a tblCommets that has 2 columns in it. The first is an identifier (1,2,3) and the second column is a comment associated with that identifier. Is it possible to use a query to pull that comment based on a user selection? So, if the user selects 1 then the comment associated with 1 is...

Tblnegative: "The reulsts are negative indicating ..." TblPositive "The resuls are positive indicating .." Is there a query that can pull the table based on a field in a form (Result)? So if result is negative the query pulls tblnegative If result is positive the query pulls tblpositive...

Hello, Is it possible to have a query that uses criteria to pull data from a specific table? For example: IIf([Result]'"Negative",(tblNegative goes here),IIf([Result]="Positive",(tblPositive goes here]. The tables are just text, but the query would be too long if it was used. Thank you.

The rowsource of the combo-box is "Negative";"Positive" and the textbox to populate is Text216. Private Sub Results_AfterUpdate() If Me.Results = "Negative" Then Me.Text216 = "Nothing was detected and the results are [Results]." Thank you.

Can the result of a combo-box be used in text in an AfterUpdate event? Example, the combo-box (Result) can be negative or positive. If it is negative a textbox is populated with the test is (combo-box here)? Thank you.

If I have a combobox (Result) that has two values in it, positive and negative. Is it possible to have a code in a query that has some text in it but also the combo-box selection? Example: Result is "Negative" The test revealed a "Negative" detection. Thank you.

I have a query that populates a report linked to a mail merge. There is an IFF statement in it that checks to see if a condition is meet. If that condition is meet some standard text results. Is it possible to put a disclaimer with the standard text. For example, IIF...