User Panel
User Panel
User Panel
|
Posted: 10/30/2011 5:47:14 AM EDT
UPDATE: The ATF-compliant version, practically complete, fully-functional and with better features: http://www.ar15.com/forums/topic.html?b=1&f=5&t=1252871
If you're using the firearms.odb database from this thread, backup your data using these instructions before trying out the newer database. Instead of the GUN table, though, open the Table1 table. I don't think I'll be making any more changes to this firearms.odb database. 
Old stuff shrunken into a spoiler: Click To View Spoiler |
|
|
|
Posted: 10/30/2011 5:53:31 AM EDT
[#1]
name of boat that sank:
|
|
|
|
Posted: 10/30/2011 6:46:30 AM EDT
[#2]
Quoted:
name of boat that sank: BOAT_NAME SUNK_DATE 
|
|
|
|
Posted: 10/30/2011 6:49:01 AM EDT
[#3]
I built an Access database for the same purpose, and it looks like you've got your bases covered.
|
|
|
|
Posted: 10/30/2011 6:53:03 AM EDT
[#4]
Didn't someone on here already do this. I am pretty sure he developed an inventory system that would work with FFL requirements, but does basically the same thing you have listed. Maybe do a forum search.
|
|
|
|
Posted: 10/30/2011 7:14:22 AM EDT
[#5]
Quoted:
Didn't someone on here already do this. I am pretty sure he developed an inventory system that would work with FFL requirements, but does basically the same thing you have listed. Maybe do a forum search. The free version of that is limited to 10 firearms. 
|
|
|
|
Posted: 10/30/2011 7:14:30 AM EDT
[#6]
Quoted:
Didn't someone on here already do this. I am pretty sure he developed an inventory system that would work with FFL requirements, but does basically the same thing you have listed. Maybe do a forum search. Wolfrage was working on it. It's not free anymore however. My Gun DB http://www.ar15.com/forums/t_1_5/1205247_MyGunDB_firearm_inventory_system_is_now_out_of_Beta_.html |
|
|
|
Posted: 10/30/2011 8:16:05 AM EDT
[#7]
This thread is very relevant to my interdasting. .
I was half-assedly working on a Bento-based template for my armory collection, but i got distracted. Bento is a Mac platform Filemaker based db program designed for morans such as myself. 
|
|
|
|
Posted: 10/30/2011 8:18:37 AM EDT
[#8]
Quoted:
name of boat that sank: 
|
|
|
|
Posted: 10/30/2011 8:23:20 AM EDT
[#9]
I had one I was working on but lost it the last computer crash. I have a backup some where but I haven't bothered to mess with it yet. I need to get on the stick and get going with it.
|
|
|
|
Posted: 10/30/2011 9:40:41 AM EDT
[#10]
Update in OP.
|
|
|
|
Posted: 10/30/2011 11:51:24 AM EDT
[#11]
Bump.
|
|
|
|
Posted: 10/30/2011 12:05:02 PM EDT
[#12]
tag
|
|
|
|
Posted: 10/30/2011 12:07:11 PM EDT
[#13]
Taggage
|
|
|
|
Posted: 10/30/2011 12:37:05 PM EDT
[#14]
not a bad Idea.
|
|
|
|
Posted: 10/30/2011 12:50:56 PM EDT
[#15]
I used a Spread Sheet but Jack Daniels was driving the Boat that Day so I am NOT exactly sure which lake or river I was on.
Impeach Obama for the Good of the Water Ways. 
|
|
|
|
Posted: 10/30/2011 12:51:28 PM EDT
[#16]
Standardize a caliber list and make it a drop down menu instead of a regular text entry field. This will help avoid inconsistencies in how it gets input, helping to make queries on caliber more accurate. This would be especially nice with larger collections when you want to see how many of one particular caliber are in the collection.
Example: .308 Win vs. 308 WIN, 12 Gauge vs. 12 GA, 9mm vs, 9 MM You can see where I'm going. Good luck with your creation! |
|
|
|
Posted: 10/30/2011 12:51:49 PM EDT
[#17]
Bump for inline edits to the OP.
|
|
|
|
Posted: 10/30/2011 12:53:25 PM EDT
[#18]
Quoted:
Quoted:
Didn't someone on here already do this. I am pretty sure he developed an inventory system that would work with FFL requirements, but does basically the same thing you have listed. Maybe do a forum search. The free version of that is limited to 10 firearms. Good point. Could be useful. |
|
|
|
Posted: 10/30/2011 12:53:34 PM EDT
[#19]
Quoted:
Standardize a caliber list and make it a drop down menu instead of a regular text entry field. This will help avoid inconsistencies in how it gets input, helping to make queries on caliber more accurate. This would be especially nice with larger collections when you want to see how many of one particular caliber are in the collection. Example: .308 Win vs. 308 WIN, 12 Gauge vs. 12 GA, 9mm vs, 9 MM You can see where I'm going. Good luck with your creation! Yes, I thought about that, and will probably do that if there's a mostly comprehensive caliber list already available. 
|
|
|
|
Posted: 10/30/2011 12:59:03 PM EDT
[#20]
Quoted:
Quoted:
Standardize a caliber list and make it a drop down menu instead of a regular text entry field. This will help avoid inconsistencies in how it gets input, helping to make queries on caliber more accurate. This would be especially nice with larger collections when you want to see how many of one particular caliber are in the collection. Example: .308 Win vs. 308 WIN, 12 Gauge vs. 12 GA, 9mm vs, 9 MM You can see where I'm going. Good luck with your creation! Yes, I thought about that, and will probably do that if there's a mostly comprehensive caliber list already available. There are lists, it just depends on how long and inclusive you want them to be. http://en.wikipedia.org/wiki/List_of_handgun_cartridges http://en.wikipedia.org/wiki/List_of_rifle_cartridges |
|
|
|
Posted: 10/30/2011 1:08:27 PM EDT
[#21]
If you have a smartphone, there are several apps that already do this for free.
|
|
|
|
Posted: 10/30/2011 1:10:44 PM EDT
[#22]
C&R yes/no field so you can easily filter to print a report.
|
|
|
|
Posted: 10/30/2011 1:11:13 PM EDT
[#23]
Quoted: If you have a smartphone, there are several apps that already do this for free. True, but do you trust the security of a smart phone? |
|
|
|
Posted: 10/30/2011 1:30:57 PM EDT
[#24]
Quoted:
Quoted:
If you have a smartphone, there are several apps that already do this for free. True, but do you trust the security of a smart phone? Provided you password protect your phone and program, its about as secure as having your list on a laptop. At least if there is a break in or fire when you're gone, you'll probably have your phone on you. |
|
|
|
Posted: 10/30/2011 2:15:21 PM EDT
[#25]
I downloaded your file and started using it. First thing I found was that there is no place to enter accessories. Most of my rifles have scopes that are worth as much as the rifle in addition to special triggers and other items.
There is plenty of room for editing so I'll let you know what I come up with. |
|
|
|
Posted: 10/30/2011 2:28:42 PM EDT
[#26]
Quoted:
C&R yes/no field so you can easily filter to print a report. Good point. |
|
|
|
Posted: 10/30/2011 2:41:06 PM EDT
[#27]
Cool !!
|
|
|
|
Posted: 10/31/2011 5:10:02 AM EDT
[#29]
Bump for the daytime and weekday crew.
|
|
|
|
Posted: 10/31/2011 12:59:51 PM EDT
[#30]
Quoted: Quoted: Didn't someone on here already do this. I am pretty sure he developed an inventory system that would work with FFL requirements, but does basically the same thing you have listed. Maybe do a forum search. The free version of that is limited to 10 firearms. Bummer. I quit following that thread too soon I guess. Looks like you are making good progress though. |
|
|
|
Posted: 10/31/2011 1:00:56 PM EDT
[#31]
Quoted:
Quoted:
name of boat that sank: BOAT_NAME SUNK_DATE Arfcom Deep Sea Fishing Trip NO. ______ |
|
|
|
Posted: 10/31/2011 6:18:15 PM EDT
[#32]
List of calibers, actions, firearm types: Google Spreadsheet (no sign-in required)
Here are some standards/conventions for the list: 1 - Group by American/English/SAE/whatever, then by metric (e.g., .22 LR, .22 WMR, .38 Special, .45 ACP then 9x19 mm Parabellum, 10 mm Auto, etc.) 2 - Generally, if there is just one word modifying the caliber, spell that word out (e.g., "Parabellum"). If there are two words that you just never see abbreviated to initials, then spell them out. 3 - Put a space between the number and "mm" (e.g., "10 mm"). 4 - Actually, always put a space after the measurements (e.g., .22 LR, 9x19 mm). I'm doing it this way instead of taking it straight off of Wikipedia because I honestly don't care about 2.7 mm Kolibri unless someone who might use this database actually wants that as an available entry. Maybe someday way way way down the road I or someone else will make the list more betterer. Also in the Google Spreadsheet are columns for "Action" and "Firearm Type." |
|
|
|
Posted: 10/31/2011 7:25:22 PM EDT
[#33]
So I down loaded open office, down loaded the zip that is at the very top of your first post, and I can input the first firearm, it goes to the 2nd, put in that info, and it says that there is an error, it can't be saved. I have no idea what its getting hung up on. Its still saying "read only", but not sure why that is, or if it matters. It looks like it could be very useful, but not sure if I'm using it right.
|
|
|
|
Posted: 10/31/2011 7:26:44 PM EDT
[#34]
Good to see i'm not the only one working on a database system ;)
Suggestion though? Check out the ATF ruling to see what requirements you'd need to meet if you want to make it ATF compliant as a digital bound book. If you need a link, let me know. If you don't care about that, then no worries heh |
|
|
|
Posted: 11/1/2011 3:29:44 AM EDT
[#35]
It needs a general comments or "Notes" field in addition to the existing fields.
There's often something I want to record in addition to the standardized info. |
|
|
|
Posted: 11/1/2011 4:39:24 AM EDT
[#36]
Guns....I gave them all away......
|
|
|
|
Posted: 11/1/2011 5:19:05 AM EDT
[#37]
Quoted:
Standardize a caliber list and make it a drop down menu instead of a regular text entry field. This will help avoid inconsistencies in how it gets input, helping to make queries on caliber more accurate. This would be especially nice with larger collections when you want to see how many of one particular caliber are in the collection. Example: .308 Win vs. 308 WIN, 12 Gauge vs. 12 GA, 9mm vs, 9 MM You can see where I'm going. Good luck with your creation! 9x18, 9x19.
|
|
|
|
Posted: 11/1/2011 1:11:47 PM EDT
[#38]
Quoted:
So I down loaded open office, down loaded the zip that is at the very top of your first post, and I can input the first firearm, it goes to the 2nd, put in that info, and it says that there is an error, it can't be saved. I have no idea what its getting hung up on. Its still saying "read only", but not sure why that is, or if it matters. It looks like it could be very useful, but not sure if I'm using it right. Hmmm, I'm not sure why that is, either. What's the error message say? Anyone else getting it as "read only?" |
|
|
|
Posted: 11/1/2011 2:09:38 PM EDT
[#39]
Quoted:
Good to see i'm not the only one working on a database system ;) Suggestion though? Check out the ATF ruling to see what requirements you'd need to meet if you want to make it ATF compliant as a digital bound book. If you need a link, let me know. If you don't care about that, then no worries heh This is not meant to compete with your market, since I'm doing this for people like me who are too cheap to shell out the 20 bucks that could recoup thousands from insurance after that tragic boating accident.
If you have a link to the requirements from the ATF, I'd be happy to see it! As for implementing the requirements... Maybe when/if I get my C&R. Eh, better to not need, and have, than to need and not have, right?
|
|
|
|
Posted: 11/1/2011 2:10:33 PM EDT
[#40]
Quoted:
It needs a general comments or "Notes" field in addition to the existing fields. There's often something I want to record in addition to the standardized info. Beat you to it. 
Added that feature last night, but can't recall if I uploaded it in the zip archive. I know I did not take a screen shot of it, though. |
|
|
|
Posted: 11/1/2011 7:38:38 PM EDT
[#41]
Bump for the night crew.
|
|
|
|
Posted: 11/2/2011 7:27:49 AM EDT
[#42]
Quoted:
This is not meant to compete with your market, since I'm doing this for people like me who are too cheap to shell out the 20 bucks that could recoup thousands from insurance after that tragic boating accident. Heh Even if it were to compete, I'm all for it –– I'm the first to admit that not every system is perfect for everyone. Choices are great! :D If you have a link to the requirements from the ATF, I'd be happy to see it! As for implementing the requirements... Maybe when/if I get my C&R. Eh, better to not need, and have, than to need and not have, right? http://www.atf.gov/regulations-rulings/rulings/atf-rulings/atf-ruling-2008-2.pdf BUT GET YOUR DARNC&R! RIGHT NOW! heh not only can you get inexpensive, neat firearms sent directly to your house without transfer fees, but most online shops will give you dealer discounts –– a week after I got my C&R I bought my dad a new scope from Midway and saved $60 –– twice the cost of my license. It's sooo worth it! :D |
|
|
|
Posted: 11/2/2011 7:30:23 AM EDT
[#43]
tag
|
|
|
|
Posted: 11/4/2011 1:03:05 PM EDT
[#44]
Update: firearms-0.1.4.zip
Nearly feature-complete for current purposes. I've added some tables (not visible in the "form") for optics, holsters, and lights. Feel free to add ideas for other accessories! The form now prints on Letter-sized paper, instead of Legal. I've also created a simple query and accompanying report, so you can print a basic list of your collection: 
If you want to help, probably the most important thing to do is to suggest data categories (e.g., ATF_REQUIRED_DATA, Table1, OPTIC_table, etc.) and data fields within each category (e.g., for ATF_REQUIRED_DATA: make, model, type, serial number, etc.)!!! |
|
|
|
Posted: 11/4/2011 1:37:03 PM EDT
[#45]
bump
|
|
|
|
Posted: 11/4/2011 1:58:28 PM EDT
[#46]
Quoted:
Quoted:
This is not meant to compete with your market, since I'm doing this for people like me who are too cheap to shell out the 20 bucks that could recoup thousands from insurance after that tragic boating accident. Heh Even if it were to compete, I'm all for it –– I'm the first to admit that not every system is perfect for everyone. Choices are great! :D If you have a link to the requirements from the ATF, I'd be happy to see it! As for implementing the requirements... Maybe when/if I get my C&R. Eh, better to not need, and have, than to need and not have, right? http://www.atf.gov/regulations-rulings/rulings/atf-rulings/atf-ruling-2008-2.pdf BUT GET YOUR DARNC&R! RIGHT NOW! heh not only can you get inexpensive, neat firearms sent directly to your house without transfer fees, but most online shops will give you dealer discounts –– a week after I got my C&R I bought my dad a new scope from Midway and saved $60 –– twice the cost of my license. It's sooo worth it! :D Thanks for the link! Looks like it will be a long, long while (if ever) before this db will be ready for that crap. |
|
|
|
Posted: 11/4/2011 6:48:58 PM EDT
[#47]
Update to 0.1.6 in OP.
Please leave your comments and suggestions. This database will remain free and will be posted here in perpetuity. |
|
|
|
Posted: 11/5/2011 8:11:28 AM EDT
[#48]
|
|
|
|
Posted: 11/6/2011 4:01:33 AM EDT
[#49]
If you are having trouble inputting data and getting read only errors, make sure you actually extract the DB from the zip file. If you open it inside the zip file you won't be able to use it properly.
ETA: Thanks TC2 - the DB looks great. I am going to use it later today and see what I come up with. |
|
|
|
Posted: 11/6/2011 4:46:05 AM EDT
[#50]
tag- relevant to my interests.
|
|
|
Win a FREE Membership!
Sign up for the ARFCOM weekly newsletter and be entered to win a free ARFCOM membership. One new winner* is announced every week!
You will receive an email every Friday morning featuring the latest chatter from the hottest topics, breaking news surrounding legislation, as well as exclusive deals only available to ARFCOM email subscribers.
AR15.COM is the world's largest firearm community and is a gathering place for firearm enthusiasts of all types.
From hunters and military members, to competition shooters and general firearm enthusiasts, we welcome anyone who values and respects the way of the firearm.
Subscribe to our monthly Newsletter to receive firearm news, product discounts from your favorite Industry Partners, and more.
Copyright © 1996-2024 AR15.COM LLC. All Rights Reserved.
Any use of this content without express written consent is prohibited.
AR15.Com reserves the right to overwrite or replace any affiliate, commercial, or monetizable links, posted by users, with our own.
