Search results

I can not post the db, I am using Expression is. Thanks

I have: Expression is ([OrderDate]-[DOB])< 30 in the conditional format OrderDate 1/15/2014 DOB 1/14/2014 the DOB field does not turn red however. Thank you.

I have a field on a form OrderDate and a field DOB. I am not sure how to create an expression in conditional formatting that: =IF([DOB] - [OrderDate] <30), Then background is red So if the OrderDate is 1/1/2014 and the DOB is 1/15/2014 then the DOB field turns red If the OrderDate is...

I am using the code below to pull the inuse reagents into a form. The code works great (Thanks David R for all your help). Is it possible to only pull the inuse reagent If [QC] has a date associated with it? In other words, tblExtraction Lot Kit QC Inuse...

=GetBusinessDay([Samplecollectiondate],IIf([Text45]="Noonan Sydrome",30,IIf([Text45]="Marfan Disorder",40))) I get a #TYPE? in the Due Date. Thank you.

Could I do something like this: =If Me.Text45 = "Test1" Then GetBusinessDay([YourFieldName],30) ElseIf Text45 = "Test2" Then GetBusinessDay([YourFieldName],4 0) Basically, have different due dates based upon what test is ordered. Thank you.

I am using the code below and in the Due Date textbox: =GetBusinessDay([«datStart»],[«intDayAdd»]) I get #NAME? in the field. Do I need to reference the Order Date (which is the starting date)? Thank you. Option Compare Database Function GetBusinessDay(datStart As Date, intDayAdd As...

I'm not sure I follow. I have a form with Order Date on it that the user enters. Then there is a dropdown box on that form in which the user selects the test. There is a text box (Due Date) that I would like to have auto-populate based on the test and Order Date. If the test ordered is...

This is a new one for me and I am trying to learn more and more. I am a biologist learning programming. Thank you.

I am trying to use the code below to add 30 days if Test 1 results and 40 days if Test 2 results. Nothing happens as of right now and I am not sure why. Thank you. Order Date (user enters date) Test (user selcts panel) Order Date (user enters date) Test (user selcts panel) Select Case...

If I would like 30 days to be added if Text45 = Noonan Syndrome or 40 days to be added if it is Marfan Disorder, where do I put that in the code? There is a collectiondate field that has the startDate. For example, if Noonan Syandrome is Text.45 and in collectiondate is 4/1/2013 then Text225...

I realized that after I posted, Thank you for your help.

If Me.Text45 = "Noonan Syndrome" Or Me.Text45 = "Marfan Disorder" And Me.Text45 = "" Then Me.Text61 = DLookup("[Kit]", "[tblExtraction]", "[Inuse] = -1") Me.Text63 = DLookup("[Lot]", "[tblExtraction]", "[Inuse] = -1") Me.Text65 = DLookup("[QC]", "[tblExtraction]", "[Inuse] = -1")...

I have attached an example database that I hope helps to illustrate the idea. I need to be able to track what kit was used with what sample, but I would like to have the current lot in-use be automatically populated to reduce error. So, if I have table (tblTest): Kit Lot InUse Amp 123 Yes Amp...

How do I query against that table for the current kit Inuse? I have the form setup as a combo box, Row source is tblTest and Row source type is Table/query. Example: tblTest Kit Lot Inuse Amp 123 Yes Amp 456 No Amp 789 No Amp 099 No Amp 100 No So, Kit=Amp, Lot= 123. Thank you.

I set the DLookup in an unbound textbox and the formula appears as the control source. Is there another way to do it so that it doesn't apply the DLookup to all the records on the form? Thanks.

I use DLookup now =DLookUp("[Kit]","tblExtraction","[Inuse] = -1") The problem is that it applies the value set to Inuse to every record on the form, even if a different kit was used. Currently, with DLookup if Kit 123 is Inuse=True, then on the form all 5 records have that kit 123. If kit...

The default of pulling the Kit where [InUse]=True onto your form for the user, the multiple fields are rows on the table. As there are going to be several kits on tblTest, but only one row will be [Inuse]=True. This is the one to pull. Example: tblTest Kit Lot Inuse Amp 123 Yes Amp 456...

I need to be able to track what kit was used with what sample, but I would like to have the current lot in-use be automatically populated to reduce error. So, if I have table (tblTest): Kit Lot InUse Amp 123 Yes Amp 456 No On a form: Case 1 Kit Amp Lot 123 If on tblTest the Inuse...

The problem with DLookup is that it only pulls 1 value and replaces the previous values. I think I need to use a select statement and was trying to avoid using a combo-box, but that may be the only way.