Consulting

Page 3 of 3 FirstFirst 1 2 3
Results 41 to 50 of 50

Thread: Access time help

  1. #41
    Hi OBP

    now have a list of all BOM

    Many Thanks

    Nick
    Experience is something you don't get until just after you need it.

  2. #42
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, how does this BOM fit in with the SQL table?
    Do you need to see Old Rolls on the main data form, or can they go on a History form?

  3. #43
    Quote Originally Posted by OBP
    Nick, how does this BOM fit in with the SQL table?
    Do you need to see Old Rolls on the main data form, or can they go on a History form?
    Hi OBP

    old rolls can go in history form yes, BOM is all rolls that have any BOM associated with them , what i do is a vlookup at moment to bom table and when i enter rolls into MILL it give me a list and then i print it out and order from Stores

    Hope this helps

    Nick
    Experience is something you don't get until just after you need it.

  4. #44
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    So is the BOM table going to be in the Access database as well?

  5. #45
    Quote Originally Posted by OBP
    So is the BOM table going to be in the Access database as well?
    Yes OBP it will, it should never change unless a new order comes in and it requires BOM

    Thanks

    Nick
    Experience is something you don't get until just after you need it.

  6. #46
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, I am pulling out the Part Numbers from the BOM, should the same Part number have different descriptions?
    Like
    CW 6172DDK = KEY Ref:CW 6172DDK & CW 6172DDK DUMMY KEY

  7. #47
    Quote Originally Posted by OBP
    Nick, I am pulling out the Part Numbers from the BOM, should the same Part number have different descriptions?
    Like
    CW 6172DDK = KEY Ref:CW 6172DDK & CW 6172DDK DUMMY KEY
    Hi OBP

    CW No would be 6172
    Drawing No would be CW6172
    Part No would be CW6172DDK
    Type would be DUMMY KEY

    Hope This helps

    Thanks

    Nick
    Experience is something you don't get until just after you need it.

  8. #48
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    So should the table be laid out like that?
    As at the moment you have a lot of parts with different descriptions like the one that I have shown.
    But we have another big problem.
    The new BOM table has 8907 Rolls that are not in the SQL table. Should they be in there as well or are they old Information?

  9. #49
    Quote Originally Posted by OBP
    So should the table be laid out like that?
    As at the moment you have a lot of parts with different descriptions like the one that I have shown.
    But we have another big problem.
    The new BOM table has 8907 Rolls that are not in the SQL table. Should they be in there as well or are they old Information?
    Hi OBP

    yes if the BOM table can be laid out like that, and yes they should all be in the SQL table too

    Thanks

    Nick
    Experience is something you don't get until just after you need it.

  10. #50
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Nick, I think the database is going to be too large to post on here, so I will need your email address, can you private mail it to me?
    I need for you to have a look at it and also do a shedfull of work on it.
    All those Rolls in the BOM that are not in the SQL need all the other data added, like Customer, Delivery Terms, WORef, Grades, areas etc etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •