Search results for query: *

ok, sorry read the last 3 posts from me, the only way I can see this DB working is if I have the 3 forms in the tab control and write some code (which would be huge) saying if they type this part number in the density for the leg on press 15 has to be between 2-2.15 and the density of the center...

I also thought I could create the 3 different types of forms and you the tab control button in access so everything is on one form, but then theres no way to do the density checks

You make parts. Once each shift you have to check the density of the parts that are being made? Correct The parts are being made on presses and you have to capture which press the part was made on and what part is being made? Each part has a stardard press it will run on every night, example...

I have a Name table, Part table, PartAttitubes table (which includes dryweight,submergedweight,cdryweight,csubmergedweight,ect.) then I made a table for part,press#, and target density. I have parts that just need to fill in dryweight and submerged weight on a standard press, so I have a text...

lespaul I have two db started and I need to put them together but not sure how. dhookom Is there a way I can send you my DB to look at to show you what i have? I understand what your saying about normalization. And I did get help from someone else normalizing my db but it won't work the way I...

Yes, I could create 3 forms according to my table but the problem is I have a different density for each part and I need the operators to be able to type in the dry and submerged weight and click on calculate density and give them an error in not in the range. I have about 10 parts that would...

Thanks, for the answer to the second question, it works. I want to be able to type in a part number and date range and do a search. How can I create this? Any help would be great.

Also, I have a text box that has =[DryWeight]/[DeltaWeight]in the control source of Density and if the answer doesn't come back between2.45-249 I need the error to appear, but this code is not working. HELP Private Sub Density_BeforeUpdate(Cancel As Integer) If ((Me.Density < 2.45) Or...

sorry, I wrote "if you look at my previous reply", but I just meant the target density in my orginal message. That is everything I need to accomplish, but my problem is: of what I need to happen the only way I know how to create this database is to have 20 different forms, one for each part. I...

How do you want me to send you the link?

I want to be able to type in a part number and date range and do a search. How can I create this? Any help would be great.

I work for a Factory and we make parts, our Die-setters that are watching the parts need to do a check once a shift (we have 3 shifts). They need to record the Dry weight of the part, the submerged weight of the part, then they need to record the center Dry Weight of the part and the center...