Tool Inventory Project - Page 3

TBone · 06-27-2008, 10:25 PM

I use an excel spread sheet. I list the name and cost of the tool as well as where it was purchased. I then take a digital picture of the tool showing the model number or add the number to the tool picture. I then take a picture of the serial number plate. I add the pictures to the excel spreadsheet so that when you roll over the cell, the picture appears. This greatly cuts down on the data entry. I have also decided to start scanning the receipts and placing them in the cell with the price.

toolman · 06-28-2008, 06:07 AM

Originally Posted by rcorne01

That appears to be something like I had in mind. However, when I tried to convert it, there are several missing components that appear to be associated with MS Access 97 (listed as the requirement).

Heaven knows if there is already something out there, I would not re-invent the wheel. I may see if I can debug it. Thanks for pointing it out!

Rick

Had the same problem..

LOML Has MS 2003 and I try it on hers same problem.

But it said there was a problem in the Switchboard VB.

I have been playing with the DB and it looks to work ok.

One problem I do not like is you can not add to the Category list,

you can but you have to go to the Equipment Table and add it in the Category Field under Lookup, Row Source.

I do not like this but I will have to live with it or fix it.

jmauldin · 06-28-2008, 05:14 PM

You have just prompted me to do something I should have done a long time ago. I have done this with household items and with my gun collection. However I haven't done it with my shop (shame on me). Regardless of which system or method used, I would also take my digital camera and photograph each item, along with the serial # and model #. You could transfer to a disc for future reference.
Just a thought.
Jim in Mayberry

Badabing · 06-28-2008, 06:58 PM

This is a great idea! It also reminds me that I have to get on the ball and catalog my stuff too

What I was thinking would really be ideal is a website that actually did all the work and kept a database of every item entered so that others could then pick them from a drop down list. For example, each user of the website would get their own page where they could catalog their belongings. The site would keep an individual database for each separate user but everything ever entered would be available in a 'main' database. This way, when you enter your stuff, if someone else had already input the same thing, you would just have to pick it from a drop down menu. If not, you would enter it yourself and thereafter it would be available to everyone else on the site.

I know there are some software gurus on this site, maybe they can take this idea and run with it

rcorne01 · 06-28-2008, 08:59 PM

Thanks for all of the ideas, input, and suggestions. Just to let you know I haven't "dropped a grenade" and run - I am on vacation until the 8th of July. Relegated to dial up. Probably won't be able to do much of anything online. Will catch up and update once I get back. Hope everyone has a great 4th celebration!

NCPete · 06-29-2008, 11:03 PM

Try this for a fix, guys! http://www.openoffice.org

DavidF · 06-30-2008, 09:27 AM

This thread and Scott's fire prompted me to start a shop inventory, so hopefully I won't have any problems should the worst happen. I haven't finished yet, but the first benefit is that I now know that my tools are not insured for enough. Currently $5,000 and I am already over that with the main stationary tools. I will be using excel for the db as Access seems overkill.

rcorne01 · 07-07-2008, 09:30 PM

Back in town, will start compiling lists this week...