Search results

Anyone? What I'm asking is should I have a tblTeams, tblSeasons, tblWeeks, tblGames, etc.? My problem is that they would all be many to many relationships. Anyone have an efficient way to set this up?

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...

Thanls a lot! That was really easy. I am continually amazed how easy it is to overcomplicate things in Access. I do it constantly only to find out that the solution is sometimes quite simple. Thanks again!

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! I'll check that out!!

I don't understand how I would implement that. Sorry, but I'm still a bit new to Access.

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...

Thanks Pat! I finally realized I was taking the wrong approach and recreated the form from scratch as a form with a subform. This solved all the Dlookup problems. I still had the error problem and your NZ() suggestion fixed it. Thanks again!

Sorry for being dense. The first time I tried changing it, it didn't work. I tried again and it works fine now. Thanks! If you don't mind, I have two more questions. 1. Why do my Dlookups on frmProduction keep returning the same info regardless of the filter. I want it to show info...

Any ideas?

I don't want to pass the PartID as a filter, I want to pass the corresponding OrderDetailsID. The problem is that filtering by PartID includes all entries for a particular part across ALL po's. I basically want to filter by part and po number. If I'm correct, filtering by OrderDetailsID will...

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...

Thanks a lot! That does exactly what I want. I've been looking over the code you used and I understand most of it except for DAO. I'll look that up in my books and see if I can figure it out. I was putting this back in my original db and tidying things up and I have one more question. I...

Here is my updated example. So, except for the VBA to make the mold combo box work right, everything is the way it should be?

So then it would be wrong to use a seperate ID with autonumber in the junction table? It should have a multiple field primary key? Is this true all the time? I assume that I should leave my tblSetup and it's current relationship with tblMolds and tblParts as they were. Am I correct in...

I'm getting confused now. I don't understand why tblSetup isn't a junction table. If I create another table as a junction table (say tblUsualMold), would it's realtionship be independent of my existing realtionships or would I need to change them and create a one-to-many realtionship between...

Let me clarify myself. I don't really want to use all molds. 99% of the time a part is made from only one mold. Even when there is more than one mold that can make that part, we still only produce it from one of the molds. The only time we ever use one of the other possible molds is if the...

Anybody?

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...