Search results

Hello This is how my report looks now http://i.imgur.com/TWMgDYf.png As you can see, I have a sub report that displays the tests done and their results for each sample. When several tests are done for each sample(seen in 4th sample) it begins to take up a lot of vertical space Is there a way...

Hello This is how my report looks now http://i.imgur.com/TWMgDYf.png As you can see, I have a sub report that displays the tests done and their results for each sample. When several tests are done for each sample(seen in 4th sample) it begins to take up a lot of vertical space Is there a way...

Thank you! This works for the first problem but does not work in datasheet view

Hello I have a continuous form with a bound subform in the footer section. Is there a way (with VBA?) to set the tab order so that it tabs down to the subform in the footer after a few controls in the main form and then back to the main form after going through the subform? Also I have a form...

ah I got it to work! Thank you everyone

I am referring to the subform like Forms!QC2EntryForm![QC2TestResults subform]!TestName and Forms!QC2EntryForm![QC2TestResults subform]!form!TestName With either or them there are no error messages but the code does not function. No msgbox pops up

Thank you! Private Sub TestResult_BeforeUpdate(Cancel As Integer) If Me.TestResult < DLookup("MinValue", "QCSpecs", "ProductCode='" & Forms!QC2EntryForm!ProductCode _ & "' and TestName = '" & Me![QC2TestResults subform].Form.TestName & "'") And Me.TestResult > _ DLookup("MaxValue"...

I wrote this code Private Sub TestResult_BeforeUpdate(Cancel As Integer) If Me.TestResult < DLookup("MinValue", "QCSpecs", "criteria1='" & Forms!QC2EntryForm!ProductCode _ & " and criteria2 = '" & Forms!QC2EntryForm![QC2TestResults subform].Form.TestName & "'") And Me.TestResult > _...

Hello I have the following code Option Compare Database Private Sub TestResult_BeforeUpdate(Cancel As Integer) If Me.TestResult < DLookup("MinValue", "QCSpecs", "criteria1='" & Forms!QC2EntryForm!ProductCode _ & "and criteria2 = '" & Forms!QC2EntryForm!TestName & "'") And Me.TestResult > _...

The QCSpecs table is set up like this Product TestName MinValue MaxValue AB-100 CarbonBlack 10 15 AB-100 MFI 10 20 AB-200 CarbonBlack 16 20 the code must check the value entered in QCTestResults against the min and max value...

I'm confused about how you are designing the query. The criteria is going under TestResults?

I need my quality control database to inform the user if they are entering out of specification data and prevent it from being entered unless flagged as out of spec. Each product in my database has different quality tests that must be performed with different specifications for each product...

Hello I have a parameter query with a totals row that displays averages. Is there a way to have the average row use only specific records in its calculation based on one of the field's values WHILE still displaying all the records returned by the query. I want only data that has a "YES" value...

Can I do this automatically with VBA depending on if the field is empty of data? Some of data I query will have certain fields empty. I want these hidden for the export of the data to excel.

Then how can I modify my query (which is a parameter query) to omit or hide the null fields without affecting fields with data in them?

Hello. I have a query that I want to export to excel. For some reports certain fields may be null entirely. Is there a way to remove these fields when exporting to excel or hide them automatically? I basically want to hide the fields to make the report more printable I guess another solution...

Hello I am making a parameter query that looks up quality data by lot number. For some of the lot numbers certain fields of data may be null. How can I omit these fields in the query if they are null? OR automatically omit them when exporting them data to excel?

Let me clarify The form the product and lot number are being entered into is based on a different table "QCInfo", which stores all the test results for that lot number. So the product table has one to many with the lot numbers table, which has one to many with the QCInfo table. There will...

In my QC database I have a table of products, then a table of the production lots. Each product has multiple production lots. the lot numbers are text based on the date of the run and machine they were run on. For example lot number 130425M71 was run on the 04/25/13 on machine 7. My QC techs...

ahhh yes this works. you guys rule