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.
  • 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....

                                  Dropbox - Error - Simplify your life

                                  favicon

                                  (www.dropbox.com)

                                  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