Modeling in General
General discussions about modeling topics.
Kit Collection Software
Visit this Community
Manitoba, Canada
Member Since: August 27, 2007
entire network: 277 Posts
KitMaker Network: 25 Posts
Posted: Wednesday, July 08, 2009 - 03:48 AM UTC
I was SURE I posted this...I apologize if I did...must be the gray hairs...! What software do you guys use to try and keep track of your "stash"...? I hear a lot are using Excel, and some are using an old program called Paradox..?

I'm well into the 800's as far as kits go, and nearly 300 combined for PE and Resin. Not too huge, but gotta stop buyin duplicates, triplicates and...well, you get the idea..

Cheers, Laurie

"If it ain't broke...fix it anyway...you might learn something..."!
Visit this Community
North Carolina, United States
Member Since: February 22, 2002
entire network: 11,718 Posts
KitMaker Network: 2,584 Posts
Posted: Wednesday, July 08, 2009 - 04:08 AM UTC
I wrote my own in VB/access
Visit this Community
Oost-Vlaanderen, Belgium
Member Since: November 23, 2007
entire network: 569 Posts
KitMaker Network: 32 Posts
Posted: Wednesday, July 08, 2009 - 04:54 AM UTC
Excel will do the trick for sure. It allows you to do search and filter actions.

Ermmm, 800 kits 'not too huge'. Guys like you make me feel comfortable with my stash.
And I can show this to the missus claiming it's not too bad on my end.

Visit this Community
Ontario, Canada
Member Since: January 03, 2007
entire network: 1,505 Posts
KitMaker Network: 62 Posts
Posted: Wednesday, July 08, 2009 - 06:35 AM UTC
same for me guys!..I was looking in my closet thinking of a serious downsizing ...im at about 90 kits........was going to reduce by 20 or so...
My wife is really supportive of my hobby, which has raised my suspicions that she may be an alien... so thats not my problem......its simple a question of how many can I build in a lifetime?...
Visit this Community
Virginia, United States
Member Since: July 17, 2006
entire network: 1,558 Posts
KitMaker Network: 376 Posts
Posted: Wednesday, July 08, 2009 - 01:23 PM UTC
I use an OpenOffice database I created a couple of years back. It allows me to link multiple aftermarket items to the kit they are intended for, and has saved in a few times from buying repeat AM items. It has about 300 items so far, 200 of which are AM, and about 100 kits. It's not perfect, in that when I designed it I didn't think to make it so I could associate one AM item with multiple kits (as, for example, you would want to do with some decal sheets).
Visit this Community
Limburg, Netherlands
Member Since: November 18, 2003
entire network: 894 Posts
KitMaker Network: 127 Posts
Posted: Wednesday, July 08, 2009 - 08:45 PM UTC
Hi Laurie,

I use a piece of paper Paradox is a database program just like Microsoft Access. It is more difficult to learn but it is better in making queries. But let's not get into that kind of boring discussion....

Any kind of database is only as good as the person who made it. Using one does not solve all your problems. How do you do searches to check is you already have a kit? If you have for example a Sd kfZ 251 in your database and you search for Sd. Kfz. 251 you will not find it (because of the added dots). So setup your databse with some sense. Link tables to each other. Make a "manufacturer" table that you link to you "kit stash" table. So if you make a typo in the "kit stash" table it will give you a warning that something is wrong. You can make basic search command like search for T* instead of search for Trumpeter.

If what I told you does not really makes sense, then I advise you to use a spreadsheet like Excel because making good fool proof databeses requires some experience. Make sure to make backups of any sheet you make in Excel since anything from Microsoft crashes once in a while
Visit this Community
Virginia, United States
Member Since: May 07, 2003
entire network: 1,174 Posts
KitMaker Network: 161 Posts
Posted: Wednesday, July 08, 2009 - 11:04 PM UTC
I currently use Microsoft access program, but Im considering changing, to Hobby Collecter
Visit this Community
Western Australia, Australia
Member Since: June 05, 2007
entire network: 2,166 Posts
KitMaker Network: 473 Posts
Posted: Thursday, July 09, 2009 - 12:46 AM UTC
I just look at my stash underneath a magnifying glass.

Member Since: December 18, 2001
entire network: 12,596 Posts
KitMaker Network: 2,557 Posts
Posted: Thursday, July 09, 2009 - 01:46 AM UTC
If you do a google search, the IPMS club in Huntsville, AL had a MS Office Access model database downloadable for use. It required Access to use though, but it was user friendly. The hard part was data entry.