Results 1 to 2 of 2
  1. #1
    bushkanaka86 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2011
    Posts
    1

    Managing Inventory in Access


    Hello,

    I am very new to using Access but I was needing a database to help manage inventory at a small repair shop. We have been using Excel for a while but we are wanting a bit more functionality now. While I am good with computers in general, Access is new to me so I am having trouble figuring out how to do what I want.

    Right now, I have a way for new items to be added to the inventory through a form and they are added to my Table. However, what I am trying to do is set up a way Add/Remove items from inventory without having to look at the Table and do the math myself.

    I would like to create a form where someone can type the item ID number and it will automatically populate the name of the item and how many are on hand. Then there would be a place to type a number and either add or remove that many of that particular item.

    I was messing around with DLookUp to try and get that to work but I couldn't figure it out.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    A principle of relational database is 'input raw data, do calcs in reports'. Trying to manually manage aggregate data will drive you nuts. Input transactions of inventory in and inventory out and then design reports to calculate the balance. This has been done before. Template databases are available for adaptation to your needs. You can open one of the templates offered by MS. You can see the choices when you create a new project. Or Google: Access inventory database template.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Inventory
    By Nemacol in forum Database Design
    Replies: 2
    Last Post: 09-13-2011, 05:23 PM
  2. maintaining inventory in access
    By mmarwaha in forum Access
    Replies: 1
    Last Post: 01-16-2011, 06:23 AM
  3. Managing Point in Time
    By Stressed in forum Database Design
    Replies: 1
    Last Post: 03-09-2010, 07:55 AM
  4. Managing Point in Time
    By Stressed in forum Programming
    Replies: 0
    Last Post: 03-01-2010, 08:47 AM
  5. Creating an Inventory Form in Access
    By KIDRoach in forum Forms
    Replies: 0
    Last Post: 09-13-2009, 11:39 PM

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