Recent content by bozrdang

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