Skip to content
Collapse
? [[global:guest]]
Unread Recent
HOME SEARCH PROFILE MESSAGES 0 BOOKMARKS MEMBERS BADGES
Multitool.Org Forum
MultiTool.org • Community Header Space • Watch This Space

SAK Database (MS Access)

Scheduled Pinned Locked Moved Swiss Army Knights Forum
14 Posts 1 Posters 2.1k Views
  1. Home
  2. Tool Talk
  3. Swiss Army Knights Forum
  4. SAK Database (MS Access)
SAK Database (MS Access)
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • RedRamage Offline
    RedRamage
    Posts: 427
    RedRamage Offline
    RedRamage
    wrote on last edited by
    Quote Reply

      Hey all,

      Going through some of my old files and found this. Back about 4 years ago I massively herniated a disk in my lower back. For about two months I was very much out of commission physically. I couldn't sit for more than 5-10 seconds before the pain was too much to bear. I could stand for a while and lay flat without too much pain. My wife literally was feeding my on the floor. She'd set my dinner on the ground and I was eat it with one hand while pushing our dog away with my other! :D

      To pass time while I was in this state I was working on a Microsoft Access Database to catalog my SAKs. Obviously this is 4 years old so it might be out of date a bit but I just played with it a little bit and it seems to still work if you have MS Access. It's just a way to record you information about your collection electronically if you're so desire.

      Feel free to use it if you want... at one point I have everything entered in here that I owned... but I think I need to do a lot of updating. Anyway, here's the link:

      https://www.dropbox.com/s/v7nb8a7azezz4d3/SAKdb.mdb

      Some pics attached.

      One.jpg

      two.jpg

      three.jpg

      four.jpg

      1 Reply Last reply
      • Reinier Offline
        Reinier
        Posts: 10,743
        Reinier Offline
        Reinier
        wrote on last edited by
        #1 Quote Reply

          Looks good! I've been thinking about a database like that for years. For now, Excel works OK... ish. :)

          1 Reply Last reply
          • enki_ck Offline
            enki_ck
            Global Moderators
            Posts: 20,936
            enki_ck Offline
            enki_ck
            Global Moderators
            wrote on last edited by
            #2 Quote Reply

              Very nicely done. :hatsoff:

              1 Reply Last reply
              • nsa-x-file Offline
                nsa-x-file
                Posts: 1,270
                nsa-x-file Offline
                nsa-x-file
                wrote on last edited by
                #3 Quote Reply

                  Thanks for sharing. :salute:

                  1 Reply Last reply
                  • RedRamage Offline
                    RedRamage
                    Posts: 427
                    RedRamage Offline
                    RedRamage
                    wrote on last edited by
                    #4 Quote Reply

                      Looking at the second picture... that's the primary 'knife' display where items are added or edited. Is there anything I'm missing attribute-wise? Any field that I should add?

                      I'm thinking of adding a spot for limited edition/special run, like a Swiss Bianco sort of thing. Obviously this can be placed in notes, but if I make it an attribute that's something that can be viewed/reported on.

                      1 Reply Last reply
                      • styx Offline
                        styx
                        Posts: 9,851
                        styx Offline
                        styx
                        wrote on last edited by
                        #5 Quote Reply

                          nicely done. thanks for sharing that

                          1 Reply Last reply
                          • Reinier Offline
                            Reinier
                            Posts: 10,743
                            Reinier Offline
                            Reinier
                            wrote on last edited by
                            #6 Quote Reply

                              @RedRamage said:
                              Looking at the second picture... that's the primary 'knife' display where items are added or edited. Is there anything I'm missing attribute-wise? Any field that I should add?

                              Tang stamps? Miscellaneous attributes like material of cross & shield (nickel silver?), scale patterns/designs (company logos, laser etching, guilloché patterns)? Box included y/n, if so, what kind of box?
                              :)

                              1 Reply Last reply
                              • RedRamage Offline
                                RedRamage
                                Posts: 427
                                RedRamage Offline
                                RedRamage
                                wrote on last edited by
                                #7 Quote Reply

                                  I like some of those ideas Reinier.

                                  • I'm adding in a spot to indicate engraving on the scales and/or blade.

                                  • I'm adding a check mark for Advertising, and I may add a field to put in company or product name.

                                  • I'm adding a check mark for Original box

                                  I'm not sure how to handle tang stamp. Would this be a text field? Can we describe the different tangs easily with just a word or a (very) short phrase?

                                  1 Reply Last reply
                                  • RedRamage Offline
                                    RedRamage
                                    Posts: 427
                                    RedRamage Offline
                                    RedRamage
                                    wrote on last edited by
                                    #8 Quote Reply

                                      Okay, here's an updated version I just finished....

                                      https://www.dropbox.com/s/v7nb8a7azezz4d3/SAKdb.mdb

                                      Please comment if you would on this and any of changes you'd like to see. So far I've just added a few attributes to the List... there's no new reports yet. Those will come soon.

                                      New things are: Check box for advertising, for box, for engraving on scale or blade. Plus a spot to write what's engraved on the scale or blade.

                                      1 Reply Last reply
                                      • RedRamage Offline
                                        RedRamage
                                        Posts: 427
                                        RedRamage Offline
                                        RedRamage
                                        wrote on last edited by
                                        #9 Quote Reply

                                          Okay,

                                          Having some fun playing with this again. As indicated above, I've added check marks for if you have the Original Box, If there is Engraving on the Scale, if there is Engraving on a Blade, and if there is an advertising logo on the knife.

                                          I've also added some code so that certain fields are disabled unless a box is checked. For example, you can't add a series name or 'released' info unless the box is checked for these. Not a huge deal, but a nice little added touch in my (ever so humble) opinion.

                                          The downside of this, from what I can tell, is that there isn't an easy way to put a new version of this DB on top of an existing one. So if you start entering data on an old version, I don't think you can just upgrade to the newer version without having to redo your info.

                                          So, if anyone has a specific feature they'd like... let me know now and I'll try and work it in! Hope to have a 'final release' my this weekend.

                                          1 Reply Last reply
                                          • this_is_nascar Offline
                                            this_is_nascar
                                            Posts: 797
                                            this_is_nascar Offline
                                            this_is_nascar
                                            wrote on last edited by
                                            #10 Quote Reply

                                              @RedRamage said:
                                              Okay,

                                              Having some fun playing with this again. As indicated above, I've added check marks for if you have the Original Box, If there is Engraving on the Scale, if there is Engraving on a Blade, and if there is an advertising logo on the knife.

                                              I've also added some code so that certain fields are disabled unless a box is checked. For example, you can't add a series name or 'released' info unless the box is checked for these. Not a huge deal, but a nice little added touch in my (ever so humble) opinion.

                                              The downside of this, from what I can tell, is that there isn't an easy way to put a new version of this DB on top of an existing one. So if you start entering data on an old version, I don't think you can just upgrade to the newer version without having to redo your info.

                                              So, if anyone has a specific feature they'd like... let me know now and I'll try and work it in! Hope to have a 'final release' my this weekend.

                                              Looking forward to it.

                                              1 Reply Last reply
                                              • RedRamage Offline
                                                RedRamage
                                                Posts: 427
                                                RedRamage Offline
                                                RedRamage
                                                wrote on last edited by
                                                #11 Quote Reply

                                                  Okay, I done all the updating I'm going to do for right now on it. I added everything I discussed above and now have reports for all the different attributes. Who knows... 3-4 years from now maybe I'll dig it out and do more updating, but for right now what you see is what you get.

                                                  Use either of the links above it download it from my DropBox. Feel free to do with it as you please... Use it as is, modify and tweak it for your own use, or simply download, look at it and laugh, and then delete it.

                                                  1 Reply Last reply
                                                  • detron Offline
                                                    detron
                                                    Posts: 7,546
                                                    detron Offline
                                                    detron
                                                    wrote on last edited by
                                                    #12 Quote Reply

                                                      awesome! I tried to start something like this, but Access is not my specialty, so I got overwhelmed.

                                                      thank you for sharing!

                                                      1 Reply Last reply
                                                      • sir_mike Offline
                                                        sir_mike
                                                        Posts: 3,539
                                                        sir_mike Offline
                                                        sir_mike
                                                        wrote on last edited by
                                                        #13 Quote Reply

                                                          That looks sweet and I love Access! Thanks! :tu:

                                                          1 Reply Last reply

                                                          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

                                                          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

                                                          With your input, this post could be even better 💗

                                                          Register Login

                                                          1. Home
                                                          2. Tool Talk
                                                          3. Swiss Army Knights Forum
                                                          4. SAK Database (MS Access)
                                                          Reply
                                                          • Reply as topic
                                                          Log in to reply
                                                          COMMUNITY LINKS
                                                          EDC-TV SAKWiki GearFeed SAKSelector
                                                          Operational Funds

                                                          Help us keep the Unworkable working!

                                                          Make A Donation
                                                          November Goal: $300.00
                                                          Due Date: Nov 30
                                                          Total Receipts: $0.00
                                                          Below Goal: $300.00
                                                          0% funded
                                                          • Login

                                                          • Don't have an account? Register

                                                          • Login or register to search.
                                                          • First post
                                                            Last post
                                                          0