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