Hi,
I am working on adding to an existing database a "Test Form" that will be used to input product test data collected during product trials / validations replacing the current excel sheets. The reason I want to do that is I can build queries and store all data in one or by most 2 tables instead of 100'ds of excel worksheets. Also the only calculation involved will be Averages and Standard deviation.
The way I think i can do this is a frmTest (linked to tblTestForm) and a frmTestSubform (linked tblTestSubform) for each of the test method and I use a Switchboard form to access each form. Also frmTestForm gets info using combobox control from to other tables (tblProductinfo) and (tblTestName). Ofcourse the different forms will be using the same table/tables but certain fields of the table/tables
One of my issues is since I have different tests for a product, I wanted to try to use one form that can be tailored by the USER instead of having one form for each test method (attempt failed so far), that way I will have one table or two at most then I can run a query to manipulate the data. I would like the form to show averages and STDEV for certain attributes when the user is inputing the data so they are aware if product is passing or not. It gets better certain attributes need be calculated first.
How and which is the best way to go about it.
For example...
Product XYZ (consist of 2 items) when validated need to be tested for
1. TotalWeight
2. Strength
3. Capacity
Hence, the test forms should be setup differently. The Header of the forms on the other hand will be the same regardless which test method is used and consist of for example Machine speed, Product Name (ComboBox), Date Tested, Tested By, Trial/Validation Number, Glue Amount (lets say frmTest).
TotalWeight (lets say frmTestSubformW) - Will consist of 4 columns, 3 columns use inputed data by the tester and last column will be calculated
Column 0 - Sample Number
Column 1 - Weight1
Column 2 - Weight2
Column 3 - ([Weight2]+[Weight1])
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Strength (lets say frmTestSubformS) - Will consist of 3 columns, 2 columns use inputed data by the tester and last column will be calculated
Column 0 - Sample Number
Column 1 - ProductWeight
Column 2 - Equation goes here
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Capacity (lets say frmTestSubformC) - Will consist of 6 columns, 4 columns use inputed data by the tester and last 2 columns will be calculated
Column 0 - Sample Number
Column 1 - ProductWeight
Column 2 - Filter1Wt
Column 3 - Filter2Wt
Column 4 - ([Filter2Wt]-[Filter1Wt])
Column 5 - ([ProductWeight]-[Filter2Wt])*100
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Again all the above are made up to just give an idea of what I have in mind.
Any ideas/help is appreciated
Thank you
I am working on adding to an existing database a "Test Form" that will be used to input product test data collected during product trials / validations replacing the current excel sheets. The reason I want to do that is I can build queries and store all data in one or by most 2 tables instead of 100'ds of excel worksheets. Also the only calculation involved will be Averages and Standard deviation.
The way I think i can do this is a frmTest (linked to tblTestForm) and a frmTestSubform (linked tblTestSubform) for each of the test method and I use a Switchboard form to access each form. Also frmTestForm gets info using combobox control from to other tables (tblProductinfo) and (tblTestName). Ofcourse the different forms will be using the same table/tables but certain fields of the table/tables
One of my issues is since I have different tests for a product, I wanted to try to use one form that can be tailored by the USER instead of having one form for each test method (attempt failed so far), that way I will have one table or two at most then I can run a query to manipulate the data. I would like the form to show averages and STDEV for certain attributes when the user is inputing the data so they are aware if product is passing or not. It gets better certain attributes need be calculated first.
How and which is the best way to go about it.
For example...
Product XYZ (consist of 2 items) when validated need to be tested for
1. TotalWeight
2. Strength
3. Capacity
Hence, the test forms should be setup differently. The Header of the forms on the other hand will be the same regardless which test method is used and consist of for example Machine speed, Product Name (ComboBox), Date Tested, Tested By, Trial/Validation Number, Glue Amount (lets say frmTest).
TotalWeight (lets say frmTestSubformW) - Will consist of 4 columns, 3 columns use inputed data by the tester and last column will be calculated
Column 0 - Sample Number
Column 1 - Weight1
Column 2 - Weight2
Column 3 - ([Weight2]+[Weight1])
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Strength (lets say frmTestSubformS) - Will consist of 3 columns, 2 columns use inputed data by the tester and last column will be calculated
Column 0 - Sample Number
Column 1 - ProductWeight
Column 2 - Equation goes here
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Capacity (lets say frmTestSubformC) - Will consist of 6 columns, 4 columns use inputed data by the tester and last 2 columns will be calculated
Column 0 - Sample Number
Column 1 - ProductWeight
Column 2 - Filter1Wt
Column 3 - Filter2Wt
Column 4 - ([Filter2Wt]-[Filter1Wt])
Column 5 - ([ProductWeight]-[Filter2Wt])*100
Also while the Tester is keyin in the data, I would like frmTest to show the average and standard deviation of lets say the samples tested.
Again all the above are made up to just give an idea of what I have in mind.
Any ideas/help is appreciated
Thank you