[Boatanchors] tube inventory

[Bill Cromwell]

Hi Ken,

I have done exactly what you want a long time ago. I will recommend
adding that third column that tells you which box you put the derned
tubes in. Makes it easier to find later.

You want a straightforward database with the three fields (columns). A
fourth field to allow an index is a good idea too. You don't have to do
anything to the index so it won't slow you down. You want a "form" that
addresses the database. Two forms actually. The form you have in mind
you might name "Add new parts" and it allows you to enter the part name
"6U8A" for instance. The form then checks if you already have 6U8 in the
database and if you do it increments the count and tells which box you
are using for 6U8s so you can easily put it there. If you don't have it
already the form will add it to the database and ask you which box you
want it in. I use numbered boxes, drawers, etc.

Another form will be used when you take a tube out of inventory to use
it or sell it. That second form could be used merely to see if you have
the tube and how many. If you actually remove one (or more) it will
prompt you for that and update the count. I used mine exactly as you
have described. I sat down with a box of random tubes and pulled them
out one at a time and entered the part number. At the end all the info
was there to be used just as you desire.

Whatever database (not spreadsheet) you use you want to learn how to use
the forms associated with it. I don't use microsoft products and so I
can't give you any pointers on using MS Access. Something like MySQL may
be overkill for a ham tube inventory but it's free and there is a
version that runs on Windows. If you have a lot of tubes MS Access will
break your heart when the tables get big. But Access and it's forms can
be used with other database engines... if you use Windows. I hope this
information helps.

Good luck and...

73,

Bill  KU8H