Increment/Decrement Inventory Values

Inventory Database Calculations Example

Custom Inventory software is the most widely requested type database for our
programmers. In this
Access database example download we demonstrate the simplest method
for calculating inventory totals when creating purchase order or similar Access
forms.
This Access database download shows how you can use the Docmd.Runsql statement in the after
update (afterupdate) event to increment and decrement
inventory totals. The methods demonstrated here are only suitable for
single-user database systems since the code does not take into account the
possibility of locked table records.

The inventory calculations method shown in this example should only be
considered for a one-user inventory system. Consider using transaction processing for these types of calculations
in a multi-user database so that
record locking and update failures can be tracked to increase database integrity
and inventory calculation accuracy. Download the
Access 2000 Inventory Calculations
Example.

Our Access transaction processing example demonstrates performing multiple
database update actions and assuring that either all or non of the updates get
completed. Here's a like to our
transaction
processing example.