ARCHIVED
 tc2k11
n+1
Team Member
Joined: Jun 2008  MEX
 Posts: 9903 Feedback: 0% (0) |
Posted: 10/30/2011 9:47:14 AM
[Last Edit: 11/24/2011 10:33:25 PM by tc2k11]
THE IMAGE ABOVE IS A PAID ADVERTISEMENT 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 |
|
|
sigp226
He's not my president.
Team Member
Joined: Jun 2006  MDA
Posts: 6425 Feedback: 100% (1) Link To This Post |
Posted: 10/30/2011 9:53:31 AM
name of boat that sank:
 |
|
|
|
Posted: 10/30/2011 10:46:30 AM
Originally Posted By sigp226:
name of boat that sank: BOAT_NAME SUNK_DATE  |
|
|
Meta4
L33t Hax0r
Team Member
Joined: Sep 2004  MI, USA
Posts: 3151 Feedback: 0% (0) Link To This Post |
Posted: 10/30/2011 10:49:01 AM
I built an Access database for the same purpose, and it looks like you've got your bases covered.
|
|
|
Tommytwoguns
A .22 and a .38
Team Member
Joined: Mar 2006 SD, USA
Posts: 1842 Feedback: 100% (2) Link To This Post |
Posted: 10/30/2011 10:53:03 AM
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 11:14:22 AM
Originally Posted By Tommytwoguns:
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.  |
|
|
rooster4bravo
Member
Team Member
Joined: Apr 2008 KS, USA
Posts: 2016 Feedback: 100% (1) Link To This Post |
Posted: 10/30/2011 11:14:30 AM
Originally Posted By Tommytwoguns:
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 |
|
|
LowBeta
helical orbit
Team Member
Joined: Nov 2008  KNA
Posts: 2417 Feedback: 0% (0) Link To This Post |
Posted: 10/30/2011 12:16:05 PM
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 12:18:37 PM
Originally Posted By sigp226:
name of boat that sank: 
|
|
|
|
|
Posted: 10/30/2011 12:23:20 PM
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 1:40:41 PM
Update in OP.
 |
|
|
|
Posted: 10/30/2011 3:51:24 PM
Bump.
|
|
|
gregert12
too random to actually do anything productive
Team Member
Joined: Dec 2005 NJ, USA
Posts: 5236 Feedback: 100% (8) Link To This Post |
Posted: 10/30/2011 4:05:02 PM
tag
|
|
|
tspike
Nothing to see here, move along please...
Team Member
Joined: Mar 2001 VA, USA
Posts: 2757 Feedback: 100% (110) Link To This Post |
Posted: 10/30/2011 4:07:11 PM
Taggage
|
|
|
|
Posted: 10/30/2011 4:37:05 PM
not a bad Idea.
|
|
|
|
|
Posted: 10/30/2011 4:50:56 PM
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 4:51:28 PM
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 4:51:49 PM
Bump for inline edits to the OP.
|
|
|
|
Posted: 10/30/2011 4:53:25 PM
Originally Posted By tc2k11:
Originally Posted By Tommytwoguns:
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 4:53:34 PM
Originally Posted By jayers2:
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 4:59:03 PM
Originally Posted By tc2k11:
Originally Posted By jayers2:
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 5:08:27 PM
If you have a smartphone, there are several apps that already do this for free.
|
|
|
|
zoom6zoom
Member
Team Member
Joined: Aug 2006 VA, USA
Posts: 1838 Feedback: 100% (1) Link To This Post |
Posted: 10/30/2011 5:10:44 PM
C&R yes/no field so you can easily filter to print a report.
|
|
|
|
Bob243
Mean and Disagreeable
Team Member
Joined: Jun 2001 PA, USA
Posts: 10912 Feedback: 0% (0) Link To This Post |
Posted: 10/30/2011 5:11:13 PM
Originally Posted By dispatch55126: 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 5:30:57 PM
Originally Posted By Bob243:
Originally Posted By dispatch55126:
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 6:15:21 PM
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 6:28:42 PM
Originally Posted By zoom6zoom:
C&R yes/no field so you can easily filter to print a report. Good point. |
|
|
|
Posted: 10/30/2011 6:41:06 PM
Cool !!
|
|
|
|
|
Posted: 10/30/2011 8:33:14 PM
Bump for update.
 |
|
|
|
Posted: 10/31/2011 9:10:02 AM
Bump for the daytime and weekday crew.
|
|
|
Tommytwoguns
A .22 and a .38
Team Member
Joined: Mar 2006 SD, USA
Posts: 1843 Feedback: 100% (2) Link To This Post |
Posted: 10/31/2011 4:59:51 PM
Originally Posted By tc2k11: Originally Posted By Tommytwoguns: 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 5:00:56 PM
Originally Posted By tc2k11:
Originally Posted By sigp226:
name of boat that sank: BOAT_NAME SUNK_DATE Arfcom Deep Sea Fishing Trip NO. ______ |
|
|
|
Posted: 10/31/2011 10:18:15 PM
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 11:25:22 PM
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.
|
|
|
|
wolfrage
Member
Team Member
Joined: Jan 2010 NH, USA
Posts: 401 Feedback: 100% (1) Link To This Post |
Posted: 10/31/2011 11:26:44 PM
[Last Edit: 11/2/2011 11:28:31 AM by wolfrage]
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 7:29:44 AM
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 8:39:24 AM
Guns....I gave them all away......
|
|
|
|
LowBeta
helical orbit
Team Member
Joined: Nov 2008 KNA
Posts: 2438 Feedback: 0% (0) Link To This Post |
Posted: 11/1/2011 9:19:05 AM
Originally Posted By jayers2:
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 5:11:47 PM
Originally Posted By damcv62:
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 6:09:38 PM
Originally Posted By wolfrage:
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 6:10:33 PM
Originally Posted By Trebor:
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 11:38:38 PM
Bump for the night crew.
|
|
|
wolfrage
Member
Team Member
Joined: Jan 2010 NH, USA
Posts: 402 Feedback: 100% (1) Link To This Post |
Posted: 11/2/2011 11:27:49 AM
[Last Edit: 11/2/2011 11:32:51 AM by wolfrage]
Originally Posted By tc2k11:
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 |
|
|
stretch415
CABS A HEA
Team Member
Joined: Jan 2005 SD, USA
Posts: 15448 Feedback: 100% (229) Link To This Post |
Posted: 11/2/2011 11:30:23 AM
tag
|
|
|
|
|
Posted: 11/4/2011 5:03:05 PM
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 5:37:03 PM
bump
|
|
|
|
Posted: 11/4/2011 5:58:28 PM
Originally Posted By wolfrage:
Originally Posted By tc2k11:
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 10:48:58 PM
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 12:11:28 PM
|
|
|
Tommytwoguns
A .22 and a .38
Team Member
Joined: Mar 2006 SD, USA
Posts: 1853 Feedback: 100% (2) Link To This Post |
Posted: 11/6/2011 8:01:33 AM
[Last Edit: 11/6/2011 8:07:45 AM by Tommytwoguns]
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. |
|
|
Blackhawk101
Member
Team Member
Joined: Jan 2008 CT, USA
Posts: 2924 Feedback: 100% (1) Link To This Post |
Posted: 11/6/2011 8:46:05 AM
tag- relevant to my interests.
|
|
TUN
PRI
