Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. breadbox

    HELP,HELP,HELP

    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...
  2. breadbox

    HELP,HELP,HELP

    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
  3. breadbox

    HELP,HELP,HELP

    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...
  4. breadbox

    HELP,HELP,HELP

    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...
  5. breadbox

    HELP,HELP,HELP

    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...
  6. breadbox

    HELP,HELP,HELP

    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...
  7. breadbox

    Search Fields

    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.
  8. breadbox

    Search Fields

    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...
  9. breadbox

    HELP,HELP,HELP

    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...
  10. breadbox

    HELP,HELP,HELP

    How do you want me to send you the link?
  11. breadbox

    Search Fields

    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.
  12. breadbox

    HELP,HELP,HELP

    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...

Part and Inventory Search

Back
Top