Author Topic: Free Tool Inventory Software  (Read 5919 times)

Offline Uncle Buck

  • Site Owner/ Founding Spammer
  • Administrator
  • Can use hammer
  • *****
  • Join Date: Jun 2010
  • Posts: 7908
  • location: Kansas-Flyover Country!
  • The name of my small shop is the Skunkworks!
Free Tool Inventory Software
« on: June 17, 2010, 08:37:29 PM »
Got this gem from Keeper at Garage Hangout, it's a dandy!


Not exactly sure where to post this so I will put it in here.  I created this a few months ago after discussion on the GJ site.  Thought I would post here as well.

Background - There was a couple posts a while ago about what we all use for keeping track of our assets. After reading that there wasn't really anything out there that worked, I set to creating something that was easy to use had features that were useful. Here is what I came up with.

Quick features list:

Ability to create your own lists to include, manufacturer, category, size and type.
Ability to store photos of each item.
Ability to attach a scan of the purchase receipt.
Ability to run reports on the database, there are three reports included
- full inventory sorted by category and manufacturer.
- inventory by category
- inventory by manufacturer

It comes pre-loaded with some generic info such as sizes, manufacturers and such but you can easily edit the lists to tailor it to your needs.


Here are the download links for those that wish a copy.

If you already own Microsoft Access 2007 you can download here:

http://www.netquickposse.org/files/HomeInventoryDatabase.zip

If you do not own Microsoft Access you can download this version that includes Access Runtime 2007:

http://www.netquickposse.org/files/HomeInventoryDatabase-runtime_included.zip


BTW you can modify this to use it for your whole house.  I have categories for home electronics, home appliances, etc.


**Disclaimer** This software is free, distributed for free, I do not warrant anything, so please do not come to me if you lose your data. **End Disclaimer**
« Last Edit: June 17, 2010, 08:41:34 PM by Uncle Buck »
You boys better hold on cause i'm gonna have to stand on it!

Offline fatboy99

  • Newbie
  • *
  • Join Date: Jun 2010
  • Posts: 17
  • location: Indiana
Re: Free Tool Inventory Software
« Reply #1 on: June 29, 2010, 07:35:04 PM »
Awsome save Uncle Buck i was just looking for this couldnt remember what site it was posted on .

Offline TonyDanzah

  • Jr. Member
  • **
  • Join Date: Jul 2010
  • Posts: 68
  • The Champaigne of People
Re: Free Tool Inventory Software
« Reply #2 on: July 24, 2010, 02:07:37 PM »
 beerdude thanks very much for this

Offline m_fumich

  • Necromancer
  • Knows what a screwdriver is
  • ********
  • Join Date: Sep 2010
  • Posts: 6558
  • location: Memphis, TN
Re: Free Tool Inventory Software
« Reply #3 on: September 15, 2010, 09:52:57 PM »
I was hoping to get the version that I could modify but all I have is Office XP and it won't work with that. I tried Open Office and it doesn't work with that either. I had to go with the version that included runtime. Bummer.
I'm not a tool addict. I prefer "Dedicated Enthusiast prone to bouts of excessive exuberance."

"I love being purple." - Patrick the star fish

Offline Keeper

  • Hero Member
  • *****
  • Join Date: Sep 2010
  • Posts: 787
  • location: Oshawa, Ontario, Canada
    • My Random Photos
Re: Free Tool Inventory Software
« Reply #4 on: September 19, 2010, 07:00:46 PM »
Glad to see it made the transition.

As for a XP verison, it will not work with Office XP, but you do not need to have office to run it.  Download the version with the runtime and you can use it with out any office installed.  Office XP does not support the split pages I used.  Only Office 2007 and newer supports those features.

I used to have the full version uploaded, I will have to see if I can track it down.  It won't do you much good as you cannot edit the main forms in Office XP.
« Last Edit: September 19, 2010, 07:22:38 PM by Keeper »
Tbucket build pics: 
Build

Tbucket build pics continued: 
Build

Garage Pics are here: 
Garage

Offline Uncle Buck

  • Site Owner/ Founding Spammer
  • Administrator
  • Can use hammer
  • *****
  • Join Date: Jun 2010
  • Posts: 7908
  • location: Kansas-Flyover Country!
  • The name of my small shop is the Skunkworks!
Re: Free Tool Inventory Software
« Reply #5 on: September 19, 2010, 08:27:46 PM »
I tried to save all of the goodies I could before ol dipstick blew the GH up. Fortunately, I managed to save this one and many other great resources as well before it melted down over there!
You boys better hold on cause i'm gonna have to stand on it!

Offline Harbor Freight Shill

  • Jr. Member
  • **
  • Join Date: Dec 2010
  • Posts: 58
  • idiot HF lover
Re: Free Tool Inventory Software
« Reply #6 on: December 29, 2010, 07:44:52 PM »
Thanks for doing this. Although I'm sure in a few weeks I'm going to be so sick of inputting my tools I'll probably be cursing you.  th-wink

Offline Keeper

  • Hero Member
  • *****
  • Join Date: Sep 2010
  • Posts: 787
  • location: Oshawa, Ontario, Canada
    • My Random Photos
Re: Free Tool Inventory Software
« Reply #7 on: December 24, 2011, 01:13:30 PM »
I have been getting more and more requests for a 64 bit version of this.  I finally broke down and created it.

I cannot edit the main post so here is the link.

http://www.netquickposse.org/files/ToolDatabase_x64.zip

This is an empty db, meaning all or most of the category lists are blank so you can add only the ones you like.

There were requests for a field for "Set part number"  That is added to this version as well.

I know of only one person that has been hit with the 2GB db size limit of Access.  He fix was to basically split out some categories into a separate db. 

Have fun and remember to printout a full list once you complete it and give it to your Insurance company!
Tbucket build pics: 
Build

Tbucket build pics continued: 
Build

Garage Pics are here: 
Garage

Online Itzkwik

  • Global Moderator
  • Super Hero
  • *****
  • Join Date: Jun 2010
  • Posts: 2769
  • location: Montpelier VA
Re: Free Tool Inventory Software
« Reply #8 on: December 24, 2011, 04:07:39 PM »
Thanks Keeper. This is something I really need to do. Might put it on my New Year's resolutions list. thumbsup2
Bret

Offline Keeper

  • Hero Member
  • *****
  • Join Date: Sep 2010
  • Posts: 787
  • location: Oshawa, Ontario, Canada
    • My Random Photos
Re: Free Tool Inventory Software
« Reply #9 on: November 19, 2012, 06:12:31 PM »
The "Where does your stuff go" thread reminded me that I never really posted on this db over here.

So here is a quick copy/paste from the other place I had this posted, complete with pics.

******Original thread follows******

**The download links are at the bottom of this post**

I have finally finished this up and thanks to "diogenes" there was a way to package it up for everyone to use for free.

Background - There was a couple posts a while ago about what we all use for keeping track of our assets.  After reading that there wasn't really anything out there that worked, I set to creating something that was easy to use had features that were useful.  Here is what I came up with.

Quick features list:

Ability to create your own lists to include, manufacturer, catagory, size and type.
Ability to store photos of each item.
Ability to attach a scan of the purchase receipt.
Ability to run reports on the database, there are three reports included
- full inventory sorted by catagory and manufacturer.
- inventory by catagory
- inventory by manufacturer

It comes pre-loaded with some generic info such as sizes, manufacturers and such but you can easily edit the lists to tailor it to your needs.


For those that have not seen this before here are some screen shots:

This is the main screen: Just click a button.




The main item entry screen:




Administration screen - this is where you edit your lists: Click the list you wish to edit and it will popup.



Here is the report menu:



And here is one of the reports that are currently created:  This is the full inventory report.




Here are the download links for those that wish a copy. 

If you already own Microsoft Access 2007 you can download here:

http://www.netquickposse.org/files/HomeInventoryDatabase.zip

If you do not own Microsoft Access you can download this version that includes Access Runtime 2007:

http://www.netquickposse.org/files/HomeInventoryDatabase-runtime_included.zip

x64 Version - I have been asked a bunch for this, finally got around to creating it.  This is the empty version of the db, you can fill in all your own categories.

http://www.netquickposse.org/files/ToolDatabase_x64.zip

**Disclaimer**  This software is free, distributed for free, I do not warrant anything, so please do not come to me if you lose your data.  **End Disclaimer**
Tbucket build pics: 
Build

Tbucket build pics continued: 
Build

Garage Pics are here: 
Garage

Offline Chilidawg

  • Newbie
  • *
  • Join Date: Jun 2013
  • Posts: 48
Re: Free Tool Inventory Software
« Reply #10 on: June 03, 2013, 05:52:37 PM »
It's an old thread, I know, but thanks for this anyhow.  This will be really useful as I'm completely reorganizing my roller & top box, preparing for the move.

Offline dawg

  • Super Hero
  • ******
  • Join Date: Mar 2011
  • Posts: 1613
  • location: Kansas City
  • dreamin' about a living
Re: Free Tool Inventory Software
« Reply #11 on: June 21, 2013, 03:08:12 PM »
Just an FYI here before anyone gets carried away with creating a database. I used to use Win97 and Office '97 with Access.

The problem I ran into was the changes in the operating systems, going from Win97 to XP to Win7 . . . MS made it more and more difficult to use Access. It sometimes took downloading fixes from MS. These days I don't even bother with it. Probably planned obsolescence. Everything else still works in my old Office 97 though when using Win7 (64 bit).

I've just been using an Excel spreadsheet now days (*.xls), and like I said, it still works.

Steve
« Last Edit: June 21, 2013, 03:13:46 PM by dawg »

The Garage Gazette

Re: Free Tool Inventory Software
« Reply #11 on: June 21, 2013, 03:08:12 PM »

Tags: