Search results

I've attached the last database you posted and just added the tblColors to it. I couldn't get a screenshot of what I'm trying to describe so I'm going to explain it the best I can. Here's what I'm looking for... Select Product A from the ProductName combobox. The TestNames that appear in the...

All, I've converted the Projects web database to a client desktop version. The web version allows for tracking in the project history table based on the log in ID through the internet. The editor is not tracked on the client version. I'd like to add a field in the table "Project History" which...

JHB, I've ran into another wall and I need your help again! Product A has a "Color" QC spec but the TestResult field is a number field. I've created a table that assigns a number to a list of colors. Is it possible to add some code that says if the TestName is "Color", then change TestResult...

Ok, thanks again JHB. Very much appreciated.

Ok, I open the MainForm. Select "Product A" from the Product drop down box Input a LotNo (1111) Input "1" in the Density TestResult Input "5" in the pH Test Result Select the Save Result button The record is successfully created but my record source navigator at the bottom will not let me go to...

That's interesting. I just downloaded your database again and it's still not letting me add a new product after creating one. What could be the issue there? I'm running 2010, would that have anything to do with it?

That is exactly what I was looking for JHB. Thank you for taking the time to look at this for me. I would not have been able to figure out the SQL language or thought of the temporary table design to to make this possible. After making a record, I couldn't create a new record so I added a line...

Here's a screenshot of what I'm looking for. I'd like to select the product name, then have the corresponding test names display in the subform. Next to the test name, I'd like to enter the value of the test. Then save the record as product name, lot number, test name, and test result.

I'm still working on this guys...any help would be appreciated. Also, the tblProductSpecs is linked from another table in a separate database so I can't seperate those fields into separate tables. Please help!

spudracer, I've tried using a subform but I can't figure out how to create two or more records by using one form unless I add some code. I'm also not sure what a continuous form is and how it differs from using a subform.

pbaldy, Can you check out another thread I where I have a similar problem to this? I can't post a link apparently since I haven't had more than 10 posts but it's a thread titled "Create Multiple Records on One Form". Please review and provide any feedback!

Thank you for taking a look at it for me MarkK. I think I've been working on this too long but I am still stuck on how to create the form to enter a test value for a product with a lot number.

I've attached the tables with some sample data.

You're right Mihail, I don't think my logic on how to store this data is correct so I will gladly accept suggestions. I have multiple products and each product has tests associated with it. A value needs to be stored for that test, for that product, for that lot number. What is the best way to...

I've tried the subform and couldn't get it to work. Here's what I did... Parent form has "ProductName" and "Lot Number" from tblResults. Child form displays "TestName" from a qry based on tblProductSpecs Then I tried a subform in the child form with "Value" from tblResults. My problem is that...

Hello All, I've developing a QA/QC database for testing chemical products and I'm stuck on the best way to continue with adding multiple records by using one form. I have two tables: tblProductSpecs with two primary keys, "ProductName" and "TestName" tblResults with three primary keys...

Hello, First of all, thank you for posting this code. This is exactly what I was looking for! There are two "challenges" I'm having trouble trying to overcome with this code. First, if the users desktop is set to go to screen saver after 5 minutes and the detectidletime is set to 10 minutes...

Hello, First of all, thank you for posting this code. This is exactly what I was looking for! There are two "challenges" I'm having trouble trying to overcome with this code. First, if the users desktop is set to go to screen saver after 5 minutes and the detectidletime is set to 10 minutes...