Search results

  1. L

    BASIC Inventory Transactions to Quantity On Hand Issues

    We won't have that many transaction types yet. Just Add/Remove. So I should probably do away with transaction type. I feel like it was unnecessarily causing complications from the beginning. The only way I can see it helping is if we use a barcode scanner to enter quantities I don't know if...
  2. L

    BASIC Inventory Transactions to Quantity On Hand Issues

    I think from what I've looked into so far I'm going to keep an InitialQuantity or BaseQuantity field in my MasterInventory to serve as comparative point when I run the query (unless it's absolutely not needed). Ideally in the end I would also like some form of automation or pop up to flag when...
  3. L

    BASIC Inventory Transactions to Quantity On Hand Issues

    Hello all, I'm new to Access and am starting up a very simple lab inventory database. The transactions are simple and there are no aspects of sales involved. A lab worker needs to stock material on the floor, he removes what he needs and then logs a transaction in the database. I have a...
  4. L

    New to Access

    Hello all. I'm currently an 'adult learner' college student retraining for automation engineering. I've currently taken on a database project for my campus job and am looking for good resources and suggestions to get me through. I have some c++ coding experience but now SQL. I have just...
Top Bottom