SAK Database (MS Access)
-
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.
-
nicely done. thanks for sharing that
-
@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?
:) -
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?
-
-
Okay, here's an updated version I just finished....
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.
-
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.
-
@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.
-
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.
-
awesome! I tried to start something like this, but Access is not my specialty, so I got overwhelmed.
thank you for sharing!
-
That looks sweet and I love Access! Thanks!

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