If you don't need a history of parts in and out (with dates, etc) and only
need a current count, you can do it with a fairly simple Access application.
You could also do it with Excel, but I'm not as skilled with Excel as I am
with Access; you could try asking your questions in an Excel newsgroup if
you want to stick with Excel. One benefit to Access would be that if you
wish to expand the database functionality in the future, it will be easier
if you're already in Access. You'll have to decide which is better for you.

If you already have your Parts table set up with the fields you need, then
all you need to do is create a form based on that table. Use the form wizard
to create the form, then rearrange the controls the way you want. For the
parts in/out, you could add to the form another textbox control (which won't
be bound to any field in your table) and a command button (if the Command
Button Wizard pops up, just cancel it). The textbox will be for entering the
number in (positive) or out (negative). The command button will perform the
calculation. In design view select the command button and open its
Properties window. On the Event tab, select [Event Procedure] for the On
Click event, and then click on the button with the three dots next to it.
When the Code window opens, add code something like this:

   Me.Parts_On_Hand = Me.Parts_On_Hand + Nz(Me.txtPartsInOut,0)

This assumes Parts_On_Hand is the name of the field in your table that
contains the number of parts on hand, and txtPartsInOut is the name of the
textbox control you added to the form. You can name this textbox (and the
command button too) anything you want.

If you go this route, you'll probably also want to add some error checking,
especially on the textbox control to make sure a valid number value is
entered. You can post again (I'd suggest the formscoding group) if you have
questions about VBA code, error checking, etc.

HTH,

Carl Rapson

Thank you Daniel for responding.  The info that I need on this inventory
isn't nearly as detailed (hope I said that right).  The company that my
husband works for keeps track of PO's and the related information.  My
husband doesn't buy the parts, he just needs to be able to provide what his
company refers to as "a truck inventory" which consists of the number on hand
of each part.  I checked the MS inventory template, but either I missed the
one I need, or didn't know how to adapt it for this need.  After reading the
responses, I think I'm definitely out of my league on here.  I originally set
up the table in Excel with the columns parts number, parts description,
notes, beginning inventory, inventory on hand, inventory out, inventory in
and tried to use the formula of parts on hand = beginning inventory -
inventory out + inventory in........of course that worked for the first
calculation and was useless after that.  I tried everything I could think of
which did no good.

Again, thank yor for your response.

You need the following tables in your database:
TblPart
PartID
PartNum
PartDesc
PartNote

TblPartUse
PartUseID
PartUseDate

TblPartUseDetail
PartUseDetailID
PartUseID
PartID
PartOutQty

TblRestock
RestockID
RestockDate

TblRestockDetail
RestockDetailID
RestockID
PartID
PartInQty

You need a form/subform for entering restocking of parts. The main form
needs
to be based on TblRestock and the subform needs to be based on
TblRestockDetail.
You need a form/subform for entering the use of parts. The main form
needs to be based on TblPartUse  and the subform needs to be based on
TblPartUseDetail.

You then need a part inventory form. This form would be a continuous form
based on a query that included
TblPart, TblRestockDetail and TblPartUseDetail. The query would include
the fields
PartID, PartNum, PartDesc, PartInQty and PartOutQty. You would make this
query a Totals query by clicking on the Sigma (looks like a capital E)
button in the menu at the top. You then need to add a calculated field to
the query that looks like:
PartInventory = [SumPartInQty] - [SumPartOutQty].
Set the sort for PartNum ascending.

Your Inventory form would include the fields PartNum, PartDesc and
PartInventory.

If you need help setting this up, I can set it up for you for a very
reasonable fee. I could incorporate what you already have so you could begin
using this system in a very short period of time.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@pcdatasheet.com