Results 1 to 12 of 12
  1. #1
    Join Date
    Oct 2008
    Posts
    33

    Unanswered: item quantity update

    hi all.. i am in the process of building an inventory database..i have an issue understanding how to update the quantity of an item after the goods have been recieved..any assiatance would be appreciated..thank you all..

  2. #2
    Join Date
    Mar 2007
    Posts
    277
    I believe you should find this link very helpful.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  3. #3
    Join Date
    Oct 2008
    Posts
    33
    thanks..i will take a look and provide feedback

  4. #4
    Join Date
    Oct 2008
    Posts
    33
    i looked at the link..this i very detailed..(wellat least for me)..what i am working on is an assignment and i have to build a database that would bascically update the stock items recieved at the warehuse and reduce the stock quantity when the goods are transferred to the outlet..honestly am stuck..i got confused when i used the information in my 3NF to build the tables..is there any information you can giveto help me out..ill be very grateful..thanks

  5. #5
    Join Date
    Mar 2007
    Posts
    277
    The point of the link is that Quantity on hand is a dynamic number that should be calculated when you need it. Add up the Input and subtract the Output and there you have it.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  6. #6
    Join Date
    Oct 2008
    Posts
    33
    so would it makse sense to have a table for items recieved and one for items transferred...or just have one transaction table where i could select recievables or transfers...which one makes more sense?? please advise
    thanks

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Personally, I would use two tables, but I don't think it matters.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Oct 2008
    Posts
    33
    ok thanks..ill give it a try and if i encounter any problems i will let you know..

  9. #9
    Join Date
    Aug 2003
    Location
    Bulgaria, Plovdiv
    Posts
    36
    You may need few tables. Quantity Received, Quantity Sold, another one for Current Quantity On Hand and another 2 more for transaction statistics - detailed and summary on a monthly basis. It's a little bit complicated.

    And as data must be syncronized when you start a transaction all related statistics should be syncronized too. It's a complicated really. At least I see it in this way. If anyone can share inventory management solution it would be nice.

  10. #10
    Join Date
    Oct 2009
    Posts
    5
    I hav emy database wt up the same way as the link from RuralGuy but i have to admit it has been ages since i have done any code writing and i never really got into VBA that indepth. Where do i put the code and what do i do to get it to show me the OnHand quantity?

  11. #11
    Join Date
    Mar 2007
    Posts
    277
    You can put the code in a standard module is you want.
    RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP, ac07, ac10 - WinXP Pro, Win7 Pro
    Please reply to this forum so all may learn.

  12. #12
    Join Date
    Oct 2009
    Posts
    5
    ok so far i have iut kinda working i just can't get it to subtract the amount that was used i will keep plugging away at it thanks


Posting Permissions

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