Search results

I am trying to build a database for my fantasy football league. I want to be able to enter each team's game score for each week of every season. I have some basic knowledge of Access, but I'm a little stumped on how to setup my tables. A couple variables: 1. Teams might be added or...

I need to create a form that will record the molds that can produce a specific part. I would like this to be navigated using a combo box that the user would use to select a part and then have a subform that shows all molds that can be used to produce that part. Something similar to a normal...

Thanks to some help from some of you, I'm making some good progress on my db for work. Now, I have something I want to impliment and I'm not sure where to begin. We are a plastic manufacturing plant and I'm creating a db to enter orders, deduct daily production quantities, and produce a...

I have a form (frmOrders) and a subform (sfrmOrders) that I use to enter customer orders. I also have another form (frmProduction) that I use to enter each shifts production numbers and subtract them from the original order quantity. I am trying to set it up so that I can double click on the...

I have a form that's working pretty well, but there's one thing I'd like to make it do and I can't seem to figure it out. I work for a plastic manufacturing company. Obviously, we make product. These products are produced in molds. The purpose of my form is to create a setup instruction...

I work for a plastic injection molding company and I'm trying to create a form for setting up molds. I have tblMolds and tblParts. I then made a query from these two tables which my form is based on. I have it set up so that I select a part number from a combo box and the corresponding mold...

I am trying to learn Access. I often refer to The Northwinds sample database to figure stuff out, but something has me perplexed. When you view the "Orders Qry" query it has an employee field and it displays their full name. When you view it in design mode that same column is actually...

I have a form with a subform. The main form has Customer, PONumber, and OrderDate fields. The subform contains ProductID, QtyOrdered, QtyProduced, and QtyRemaning fields. I also have a third form that I want to open and filter when I double click the ProductID field in the subform. I've got...