Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Maintaining inventory

Discussion in 'Information Technology' started by Kathy, Jul 28, 2006.

  1. Kathy

    Kathy
    Expand Collapse
    Guest

    I have built a dbase that house information for parts (cost, manuf, part#,
    etc.) we would like to have this dbase track inventory as well. Rather than
    just having a QtyOnHand field that a user can adjust, we would like to have
    them go through a form that asks "are you adding inventory" or "are you
    depleting inventory" and then enter the # of parts added or depleted. That
    entry would then adjust the QtyOnHand. But how? How can I accomplish this?
    I have no doubt that it is a simple answer, it's just not coming to me.
    Thanks!
     
  2. Loading...

    Similar Threads Forum Date
    India Sikhs themselves should first start maintaining dignity of turban Breaking News Aug 8, 2013
    India Maintaining peace in Punjab, our responsibility: Damdami Taksal chief Breaking News Jun 14, 2012
    Maintaining relations or communion Sikh Rehat Maryada Dec 29, 2010
    maintaining our culture Interfaith Dialogues Oct 27, 2007

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Kathy,

    Take a look at MVP Allen Browne's sample, and see if you can apply it to
    your situation:

    Inventory Control: Quantity on Hand
    http://allenbrowne.com/AppInventory.html


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Kathy" wrote:

    > I have built a dbase that house information for parts (cost, manuf, part#,
    > etc.) we would like to have this dbase track inventory as well. Rather than
    > just having a QtyOnHand field that a user can adjust, we would like to have
    > them go through a form that asks "are you adding inventory" or "are you
    > depleting inventory" and then enter the # of parts added or depleted. That
    > entry would then adjust the QtyOnHand. But how? How can I accomplish this?
    > I have no doubt that it is a simple answer, it's just not coming to me.
    > Thanks!
     
  4. Kathy

    Kathy
    Expand Collapse
    Guest

    That is helpful. I was not planning on keeping separate tables for each time
    inventory was added or allocated (this dbase doesn't need to maintain
    invoicing info, etc.). I was hoping there was a simpler method, but maybe
    this is the best way.

    Thank you.

    "Tom Wickerath" wrote:

    > Hi Kathy,
    >
    > Take a look at MVP Allen Browne's sample, and see if you can apply it to
    > your situation:
    >
    > Inventory Control: Quantity on Hand
    > http://allenbrowne.com/AppInventory.html
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Kathy" wrote:
    >
    > > I have built a dbase that house information for parts (cost, manuf, part#,
    > > etc.) we would like to have this dbase track inventory as well. Rather than
    > > just having a QtyOnHand field that a user can adjust, we would like to have
    > > them go through a form that asks "are you adding inventory" or "are you
    > > depleting inventory" and then enter the # of parts added or depleted. That
    > > entry would then adjust the QtyOnHand. But how? How can I accomplish this?
    > > I have no doubt that it is a simple answer, it's just not coming to me.
    > > Thanks!
     

Share This Page