Results 1 to 2 of 2
  1. #1
    oyvlie is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2017
    Posts
    1

    Red face Inventory management by location

    Hi, I am trying to build a inventory management system in Microsoft Access, however I would appreciate some help on how to do this:



    We have several different types of inventory, and I will need to be able to create new types of inventory as this change.

    I imagine a form with: Inventory_Item, Inventory_Description

    The inventory I need to track is not being sold - so I just need to know how many pcs we have at each location.

    The pcs are moved around a lot, so I believe it will be easiest to create a transaction form with:

    Inventory_Item, Location_From, Location_To, Inventory_Amount_Moved, Date_Moved, Todays_date, Employee.

    I will also need to add new locations, so a form for location: Location_Name

    How do I create a report or a form that will show me Location1, Inventory_Item "Product A", Location1, Inventory Item "Product B", Location2, Inventory_Item "Product A" etc...

    Thanks for any help on how I can do this

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Inventory/stock management/control is not a trivial subject.
    I posted a sample database a few years back that may be of some interest. It shows equipment in various locations and allows movement of items from location to location.

    I remember the thread via the word "awkward".
    Good luck.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multiple location inventory
    By Testate in forum Access
    Replies: 4
    Last Post: 03-15-2016, 10:44 AM
  2. Inventory Location Management
    By dclark1991 in forum Database Design
    Replies: 7
    Last Post: 08-20-2015, 06:46 AM
  3. Inventory Management Design
    By dylcon in forum Access
    Replies: 6
    Last Post: 10-07-2013, 12:29 AM
  4. Inventory Management
    By shazi9b in forum Access
    Replies: 1
    Last Post: 09-21-2013, 03:09 AM
  5. Inventory management
    By Mina Garas in forum Access
    Replies: 3
    Last Post: 01-24-2012, 10:40 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums