Results 1 to 2 of 2
  1. #1
    MediaVue is offline Novice
    Windows XP Access 2007
    Join Date
    Feb 2010
    Posts
    1

    Question Inventory Database: Automatic Adjustments?

    Hey There,

    I have a database for inventory, consisting of around 70 different computer parts. My skills in Access are limited to this project...starting from scratch and reaching this wall.

    My goal is to create a form, which prompts the user to select the configuration of a new computer. After selecting the configuration, I would then like the inventory database to automatically be adjusted to the specifications.

    Basically, each item selected for the computer would decrease 1, after the "order" is completed. A Basic Inventory Adjustment.

    If this is confusing, I will gladly describe it the best i can through another thread or email if you need.



    Thank you very much if you can help

    Branden

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You may be interested in this link. http://allenbrowne.com/AppInventory.html

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

Similar Threads

  1. Inventory Database
    By kram941 in forum Access
    Replies: 2
    Last Post: 11-09-2009, 04:28 PM
  2. Database design for simple inventory
    By toptech in forum Database Design
    Replies: 12
    Last Post: 10-24-2009, 07:24 AM
  3. automatic row insert
    By Jerry8989 in forum Forms
    Replies: 7
    Last Post: 09-29-2009, 06:50 AM
  4. Automatic Syncronization
    By Katada in forum Programming
    Replies: 0
    Last Post: 04-25-2006, 03:36 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