Search results

Close. That is what it currently does, however as it stands now the user has to click each individual test in the testbin subform, to input the data for each of those individually in tblTestDetails. As long as they select a testbin, all of the tests in that bin will be run. Therefore there is...

I have two tables that store information input into a mainform/subform. The two tables have a similar relationship to an orders/order details type system. The mainform records data in to the test table and the subfrom records it into the testdetails table. The testdetails table stores the...

That suggestion did work for populating the subform. However the issue now is that, the subform that becomes populated needs to input that data into tbltestdetails, linked on the testID from tblTestData. The data from the main form is input in to tblTestData just fine, however no data is input...

What I have is a form that takes in information regarding test data. Each test run can record data for multiple requirements. I am able to pull all data fine, however in order to make it easier on the user i was hoping to populate the requirements subform based on a selection of "test group"...

I know this is a late reply, however i have been actively trying to come up with a solution that works. Pat, I had considered that, however without TestGroupID the only way to store test data for a test run that gathers data for multiple ASRLineItems, is to store multiple values in the...

I have a DB that is being used to track testing for various programs. The goal is to log the various phases and testing parameters that each program will go through. Each program will have multiple test vehicles. My question comes in the, attached picture, the area outlined in blue. The...

I understand how i can set the tab control on load, how do find what the openform openargs value is so i can set tab based on that. I tried to run the event and read the openargs value, but, at least if i did it right, both methods to call the form show openargs as blank.

I have a, hopefully, quick question. I have a "view" form, attached as the first attachment, that allows users to view current test vehicles or enter a new one. Attached as the second picture are tabs on the new vehicle form that opens when either the "new vehicle" button or the blue vehicle...

Thank you very much. In case anyone finds this later in their search for a solution, pbaldy was right, just a dumb syntax error. One other thing I had to do, in my situation, was that due to the "choice of program" being on the currently used form, I had to use dlookup in VBA on an...

Attached is a picture of a query I have. It returns the number of test days a program has used, stored in Days. I have a form, second attachment, where a user is able to select which program they want to lookup, this is shown in a form with comboBox dropdown. When the user selects which program...

I am brand new at building a Database, so everything I have done I have been self taught using as many resources on the internet as I could. I have built a Database and wanted to get some feedback on the layout, and see if there is anything that can be improved upon for robustness and error...

I have a crosstab query that I would like to sum data across. Each row is a seperate experimental product, and each column is a test phase that each product goes through. The data is the number of days each product was in each test phase. What I need is the sum total of days that all products...

I think i figured out how to do it on my own. If there is a better way let me know. The next thing i want to do is if we are moving to a new test product, it is giving me a zero, I'd like no data if it is a new test product. Here is the do loop i am currently using: Do While Not rst1.EOF...

Ok so I went to the link provided and imported and used the code and it works mostly as I want it to. In my case I have a list of test items with categories, i would like the math calculation for the days to only fire if the test items are the same. Public Function FrequencyCalc()...

I have a database that stores information for lab testing. Each time a tech does a "step" in the test process he logs it in the table, using an input form. There are different categories, for example preparation, testing, analysis, etc, and each of those steps take time. I have the form...