Good Evening Everyone:
I'm a model railroader, and I am modeling a small shortline in southern Colorado. As I am sure you can appreciate, there are many flavors of model railroaders, some like to build beautiful trains that run through spectacular scenery, but dont DO much, others of us put the focus on moving "Freight" Im one of those. Part of moving "Freight" is keeping track of what each car is carrying, where it came from and where its going. This is commonly done with paper waybills and car cards -- each car card identifies a specific car, and the waybill explains where and how it is going (see this link for additional info if you are interested)
There are a number of different forms out there, and also various pieces of software to help create the forms and paperwork. I happen to enjoy developing databases, and also need to save money, so I chose to develop my own database to generate the paperwork etc.
I've attached a copy of my database written in access, and I am starting this thread as a place to post any questions that come up.
The first one is related to the query that drives the frmFreightWaybill (called QryWaybills). For some reason, when I run that query, it shows up each entry in TblWaybills twice. I suspect its related to TblRoads and the way that I am pulling that value, b/c it started when I added that part of the query, but I'm not sure how to solve it
The second item is that I want to begin the process of cleaning it up and making it look "professional" I have no interest in selling it or anything, but I do want it to look good, like someone who actually knows what he's doing developed it.
I would sure appreciate any help or comments that you can offer.
SLRG_Waybills_21_to_Send.zip
Thanks
Tim