Access

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hi,

I'm creating an Access database to track inventory on
parts. I would like to automate the total in stock.
Therefore, when a part is removed (manually), the stock
amount is depleated automatically. Any suggestions or
advice is appreciated. Thank you!
 
I don't think you should only keep the results of doing an actual inventory
count in a table. Calculate the stock dynamically using a query to increment
or decrement the amount.
 
There are two schools of thought here:

1. When the part is removed/sold/waste/whatever, fire VBA code to update
the QtyOnHand field (whatever you may be calling it). reverse the process
for additions, returns, etc.

2. Compute the QtyOnHand every time you display the part info by adding all
purchases and subtracting all uses.

#2 is better in my opinion, as there is no stored calculated value, and the
total is easy to compute. #1 requires some pretty serious error handling in
the event of a transaction that does not finish properly.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 
Back
Top