HELP,HELP,HELP

[breadbox]

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 submerged weight of the part and I was calling is C Dry Weight and C Submerged weight so there was a duplicate field in the table. The form with Dry Weight , Submerged Weight, C Dry Weight and C Submerged Weight are parts running on one press. The form that has Dry Weight 9, Submerged Weight 9,C Dry Wgt 9, C SUbmerged Wgt9, Dry Weight 15, Submerged Weight 15, and so on, means the parts are running on two press (press 9 and 15) and you have to record all that information once a night.

So weighing these parts the weights might vary and they have to record them so we can track our efficiency and are able to go back and look at the records if we have a problem with them.

See example below of a part running on one press:

Part Number:11111111
Code Number 12345A
Time 1:25PM
Initials MN
2/20/2007
Dry Weight 8.28
Submerged Weight 4.775
Target Densities Delta Weight 3.505
2.35-2.41 Density 2.36



Center Dry Weight 25.326
Submerged Weight 15.2
Target Densities Delta Weight 10.126
2.46-2.51 Density 2.50

And the target Densities is 2.46-2.51 so if the number in the Density field doesn't fit that criteria they are doing something wrong and need to stop the press and check there work.


Delta Weight is =[Dry Weight]-[Submerged Weight]
Density is =[Dry Weight]/[Delta Weight]

then for the center I used =[C Dry Weight]-[C Submerged Weight]
and =[C Dry Weight]/[C Delta Weight]

The bad thing about using one form is every part as a different Target Densities the range can fall into, if you look at my previous reply the target density was 2.35-2.41 for top part and 2.46-2.51 for the bottom and those targets aren't true for all parts, each part has a different target.

Any help would be great, Thanks

 

[lespaul]

if you look at my previous reply

could you provide a link to that?

What exactly is your problem? I think it's:

each part has a different target.

In that case, the table that stores the targets needs to have the partid added to it so that you can find the correct target for that part.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[breadbox]

How do you want me to send you the link?

 

[SkipVought]

The Thread has a reference number, like this thread's reference number is...

thread181-1389214

Look up at the TOP.

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[breadbox]

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 talked to other people and they told me to use a subform but I'm not sure how to use a subform and make all my Calculations come out and have all those fields on the subform????

 

[lespaul]

why would you need a different form for every part? Presumably you have a Parts table (PartID, Name, Description, SKU, ???)...create a form based on the table (there's a wizard that can do that for you).

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[breadbox]

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 use form one, so how would I do this if they all have different densities? does that make since?

 

[lespaul]

No this doesn't make sense.

So you have a Parts table? (Yes? No?) I'm going to guess that it has fields like the ones I showed above plus another field called density? Is that right? Or you have another table that stores acceptable density?

You need to check when the user is entering some information in a form that the density they are entering is within a valid range?

Leslie

 

[dhookom]

I have created many inspection solutions. The key is to normalize your table structure so that you are not storing measurement attribute information in field names. Every numeric value entered by your users should create a new record in a table. Your table structure resembles a spreadsheet which is causing you issues.

For instance, if I wanted to record the Height, Width, and Length of an item, I would not create three fields. My solution would create three records in a related table.
[tt][blue]
tblInspections
===================
InspID autonumber primary key
InspDateTime
InspBy
InspPartNumber

tblInspectionResults
====================
InspResultsID
InspID links to tblInspections.InspID
InspCharacteristic values like Width, Height, and Length
InspValue
[/blue][/tt]

This would allow me to create a table of acceptable limits by characteristic and part number.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[breadbox]

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 need it too.
HELP

 

[dhookom]

I prefer to answer questions in public forums. I have accepted files but only when it seems there is a simple issue the OP can't figure out. I generally don't accept files that require a major re-design.

If you have questions regarding normalization and theory, just ask them here where you will get lots of help. You already have Leslie's attention and she is very good with providing this type of assistance.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[breadbox]

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 box for dry weight to fill in, a text box for submerged weight to fill in then a calulate button to click for the density

then I have other parts that run in different molders so you have to report all them which would be:
Press 15:Leg dry weight and submerged weight then click density
Press 15:Center dry weight and submerged weight then click density
Press 9:Leg dry weight and submerged weight then click density
Press 9:Center dry weight and submerged weight then click density
Each one of those that you have to fill in has a different density
If I make one big form with all those field the opertors will get confused on what to fill in (yes they should know but if the fields are there and they don't need them for those parts they will get confused)I hope all this makes since, its hard to explain thats why I wanted to show you because then you would understand why its not coming together, its works now with 20 forms but I need to break it down I know.

 

[lespaul]

I guess part of my problem is I don't understand what you mean when you say:

I have parts that just need to fill in dryweight and submerged weight on a standard press, so I have a text box for dry weight to fill in, a text box for submerged weight to fill in then a calulate button to click for the density

You make parts. Once each shift you have to check the density of the parts that are being made? 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? You check the density by weighing the part both dry and wet weight? Then some calculation is performed to get the actual density and you check to see the actual density falls within some predefined range?

What are the fields in your Name, Part and PartAttribute tables? How are they related? You also have the 'other' table that contains Part, Press# and TargetDensity....So if I make Part#1 on Press#1 it's going to have a different target density than if I make Part#1 on Press#6?

Is the PartAttribute table where you are storing what Duane calls the "Inspection" information? The Shift, Date Time and performer of the check?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[breadbox]

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 part#1 will also run on a press which has 3 molders, Molder 15, Molder 20, Molder 51, so you have to check the dry weight, submerged weight on each Molder once a night, The tricky part here is: on the part you have to get the dry weight and submerged weight of the Leg on molder15 and the dry and submerged on the center of the part on molder15. So you have to calculate the leg density and the center density
You check the density by weighing the part both dry and wet weight? yes
Then some calculation is performed to get the actual density and you check to see the actual density falls within some predefined range?yes

What are the fields in your Name-Just Name, PersonID(AutoNumber)
Parttable-the part numbers, PArtID-Autonumber
and PartAttribute tables? dryweight,submergerd weight(all of those fields,date,PartID(to link tables)
You also have the 'other' table that contains Part, Press# and TargetDensity-I added this table hoping it would work

Is the PartAttribute table where you are storing what Duane calls the "Inspection" information? The Shift, Date Time and performer of the check?yes

 

[breadbox]

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

 

[breadbox]

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 on press 15 has to be between 2.50-2.56, and so on and so on