Page updated on 09-20-2017

Kitsdb - Collections Manager


pmmsc
03-22-2016, 07:53 AM
Hello everyone,

At a few weeks ago happened to me something that is not the first time it happens. I bought a kit and when I got home I noticed had the same kit. I was damned!!! However, there was nothing else to do...
After this episode and being a good 30 minutes looking for my kits collection, I decided I had to find a way to organize and catalog the collection of models, in order to always have at hand the information of my kits.
The years go by and we came to a point where sometimes no longer remember this or that kit we have.
Because of this, I decided to make a program to catalog and, thereby, have in computerized form, my collection kits. Had to be a simple and easy to use program. I thought to do a table in Excel, but despite being practical, was not ideal. Therefore, I decided to take my BD's programmer experience and create a database practical and intuitive ... as I thought it would not be the only person in need of such a tool, I decided to do the program in Microsoft Access to be able to share with all.
I gave him the name of Kitsdb - Collections Manager. Has the Portuguese and English languages. It works in Microsoft Access versions 2007, 2010, 2013 and 2016. For those who do not have Access, Microsoft have available on your website to download a "runtime" version of Access that allows read and execute BD's. The program is all it programmable, one can adjust it to your needs and tastes. For this, you need a full version of Access.

The download link is:
https://www.dropbox.com/s/57eh9m2tqv7bz40/Kitsdb.rar?dl=0

I also share a few pictures of some screens in the program.

I hope you enjoy it and it is a useful tool...
If anyone has any opinion or improvement that thought that the program should have or do not hesitate to say, I would like to have your feedback in order to help, if possible, to have a program that helps you to organize your collections.
Model making is not only cut, paste and paint... the organization is also a very important factor, the more organized the better the results...
My best regards to all.


Pedro Cunha

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xtl1/t31.0-8/12525168_501915273329786_6661828870298478919_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xla1/t31.0-8/12888687_501915349996445_5450665660302320645_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xla1/t31.0-8/12513914_501915389996441_4208489718024917496_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xft1/t31.0-8/12888667_501915293329784_6683692667585042180_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xap1/t31.0-8/12719501_501915316663115_1998206834975004187_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xat1/t31.0-8/12322583_501915286663118_5565392442826040131_o.png

https://scontent-lhr3-1.xx.fbcdn.net/hphotos-xfa1/t31.0-8/12891091_501915343329779_1761963671865282403_o.png

da_ashman
03-22-2016, 07:01 PM
Great Idea, but i think Scale mates beat you too it awhile ago.
https://www.scalemates.com/

BVC500
03-22-2016, 09:29 PM
Thanks! I'm going to give it a try!

gasdriverca
03-23-2016, 06:16 PM
Yeah...scalemates beat ya to it buddy. looks a cool program though.

pmmsc
03-24-2016, 05:29 AM
Hello everyone,

I would first like to thank your comments. It's good to know you liked the program. :smile:

I know well the Scalemates website and I am also a user. It's a great website. The team that took the idea and developed the database is to be congratulated. It's a great place where we can find everything that is related with our kits.

As an autodidact I am and how I like to develop support tools to help us in day to day in this magnificent hobby, I decided to create this program.
The idea was born with the need to have the information of the kits I have without having to depend on an internet connection. As I like to help the modeling community, shared the program to make available to everyone a tool that can help organize your kits collections.
I have no aim to develop a program that makes competition with other programs, or gain anything from it.

Like you, I am only a modeler who likes to help and share to the community my knowledge. :)

My best regards to all.

pmmsc
03-24-2016, 12:11 PM
Hello everyone!

Taking into account the various suggestions and opinions made to me during these days in the various places where I published the program, will make a new version including the following options:
- Create shopping lists, in order to make list of tools, paints and other items that we will need to by.
- Create a module to enable the registration of kits that we want to buy.
- Events Calendar, so you do not forget any date!

Some suggestions were about the possibility of connection with the Scalemates site database, but the only way we can use the information posted on the site is even exporting the site lists in .csv format!
Taking into account that does not export all data and as the .csv file would have to be worked and prepared to be able to be imported into Kitsdb program, does not justify such an operation, because the information is not complete and this operation requires advanced knowledge of access and excel ... Unfortunately not all have this knowledge ...

Anyway, soon give news of the new version. Then I will see how best way to copy the current version of the data to the new version ... in order to donít lose data!

My best regards to all.

pmmsc
03-26-2016, 08:18 PM
Hello everyone!

As promised, here is the program with the upgrade. :)

The new features are:
- Event Calendar, allows log all events that we find important.
- Shopping lists, allows you to create shopping lists with all the stuff we need.
- Wish Kits, allows recording all the kits we intend to acquire.

Slightly changed the layout of some buttons and created new screens for the system tables (Data System).

Could not let the program as it was, after announcing that it would make an improved version with new features. It was with a feeling of unfinished work... :rolleyes:

So, get to work and made new Kitsdb 2.0 program in a lightning operation ... with few hours of sleep ... but with the mission accomplished...

Download Link:
https://www.dropbox.com/s/55jyk7ex00lrgt4/Kitsdb2.rar?dl=0

As I said earlier, I do not want to gain anything from this. The program Kitsdb - Collections Manager is not designed to compete with anyone ... Being modeler like all of you, only share my knowledge and works to contribute to the community. As such, I do not compare this to other programs, such as the scalemates, which in my opinion, is the best program of all. I am user of this excellent platform itself.

Kitsdb is just another one of the various existing programs for the purpose it was designed, manage our kits collections.

Greetings to all and good Easter! :)

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xfp1/t31.0-8/12916174_504967579691222_1225096220053167072_o.jpg

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xpt1/t31.0-8/12901126_504967583024555_3594987958769686651_o.jpg

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xla1/t31.0-8/12795121_504967586357888_2695502192707271472_o.jpg

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xap1/t31.0-8/12525466_504967636357883_2447219915325653134_o.jpg

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xaf1/t31.0-8/12891123_504967646357882_2974584199317397395_o.jpg

https://scontent.flis2-1.fna.fbcdn.net/hphotos-xtf1/t31.0-8/12593938_504967649691215_7164798347026493644_o.jpg

Add your comment to this topic!