I’ve been writing a lot about my gunsmith database and application lately. It has been my largest database project to date by far and has been a really great learning opportunity. I’ve learned a lot about Visual Basic (this was my first project of really any size with VB). I’ve learned a lot about building […]
Tag: gunsmith db
Gunsmith Db and App Part 5: Search
We have already discussed the gunsmith database and app in depth. If you want to catch up, there are posts an overview, adding customers, acquisition flow and code, and disposition flow and code. In this post, we will go over the third and final major function of the app: searching. Sometimes, the user may only […]
Gunsmith Db and App Part 4.2: Disposition Code
In Part 4.1, I showed the user flow for disposing of a gun. In this part, we’ll go over the VB code and MySQL commands to get the disposition working. Search For An Acquisition Transaction General Overview VB checks each of the textboxes in the GUI and creates a MySQL query to reflect the criteria the user […]
Gunsmith Db and App Part 4.1: Disposition Flow
Hey! Before I get into details on today’s post, I want to point out that I’ve added a way for you to subscribe to new blog posts! Just enter your email address under SUBSCRIBE on the right side of the site and you will receive an email when I publish a new post! In Part […]
Gunsmith Db and App Part 3.2: Acquisition Code
In Part 3.1, I showed the user flow for acquiring a gun. In this portion, we will go over the VB code and MySQL commands to get the acquisition working. Search For a New Customer General Overview VB checks each of the textboxes in the customer search panel and adds those values to a string, […]
Gunsmith Db and App Part 3.1: Acquisition Flow
In Part 2 of this series, I discussed how I added the ability for a user to create a new customer in the database. In this part, we will discuss how a user will track an acquisition and how I set it up in VB and MySQL. If you’d like to follow along, you can install […]
Gunsmith Db and App Part 2: Adding Customers
publish In Gunsmith Db and App Part 1 I discussed the overall goal of this project and an overview of where I was at that time. I finally had the time (and desire) to pick this project up again and realized pretty quickly that I needed to change how the database is designed. Previously, I […]
Gunsmith Db and App Part 1: Overview
Background I have a friend who owns his own gunsmith business. By law, he must track the acquisition and disposition of his guns. His current method of doing this is by filling out, by hand, papers issued by the government. Once he has so many entries in his logbook, it gets stored away for a […]