Search results

My database contains a table of many recipes, each recipe belongs to one specific category. I also have a table of many different containers, all (but one) of which is specific to a recipe category (which links the two tables). My query is currently designed to show containers based on each...

Fixed it - when I created the report initially, my finished product primary key was based on both finished product ID and batch ID. It worked fine, so I went on to tweak my form/subform for entering recipes. In its development, I took some great advice from Pat Hartman to build recipes on...

Thank you Wiklendt - I will definitely want to 'pretty up' these forms/reports once I get things working the way I need/want them to. There will only be a limited number of categories and container sizes anyway - I think I got carried away with the concept of normalizing data and simplifying...

Did I design the form/subform poorly or incorrectly, or just wrong for being able to plant this kind of safeguard? Well, perhaps the 'flag' on the Main form's footer asking if '100% rule met?' will have to suffice. We do not have many data entry people - it was simply a safeguard. Thanks anyway.

Let me try again with db3 - sorry. I didn't think I had that many drop-downs. I am getting 'somewhere' though. Now I'm on a record (which I had already entered with only 30% total as a test) and it 'beeps' me with my 'Total must equal 100%' message (YES!) but it won't let me go anywhere so...

I stripped away the confidential info from the tables but hope I've left enough so that you can see what I am doing wrong! I only left the tables, main form and the subform in question . . . and so appreciate your taking the time to help me. Here is db2.zip, warts and all!

I've tried them both, Bob Larson, and neither one of the code versions works. I even tried saving and closing the db, thinking maybe that would work, but it doesn't. I don't get any error messages, and it isn't in a loop (both of which I've had occur before) so maybe that's progress. I've...

It displays: 80.00% on the record it lets me pass right on through and go on to the next record . . .

Main form displays as: 100.00% Control Source Name: TotalIngrPercent Control Source: =frmRecipeDetails.Form!TotalPercent Code in Before Update Event on Form: Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.TotalPercent <> 1 Then MsgBox "Total must equal 100%" '-- This...

It's not working so I'm not at all sure I'm doing this correctly. I have a control on the subform footer which is a Sum function (adding the percentages as ingredients are added) called TotalPercent. On the main form I have a visible control TotalIngrPercent with the Caption 'Has the 100% rule...

Thank you, thank you! I will try it out tomorrow and Thursday. Not SO much different than COBOL, eh? I really do appreciate the help.

Thanks for your response, Rural Guy. I've read more about the Before Update events specifically and know this is what I need. Would you help me with the code, or lead me to a good resource? In COBOL it would be something like: If TotalIngrPercent not equal to 100 then display...

Our recipes are entered in terms of what percent each ingredient contributes to the finished product. This percentage is part of the data entry of individual ingredients which takes place on the subform. The total percent is being calculated on the footer, and is visible on the main form...

Thank you, Bob Larson. I was able to figure out how to link the subform to the form and it WORKS!!

I changed the formula reference as you suggested, but the results are still the same. I discovered I now have more problems than I thought - I can no longer add items using the subform. It is 'locked in place' on a single ingredient. It's amazing (and terribly frustrating) how solving one...

I added 'txt' to the names but the results are the same. I have attached my db in case that will help. The issue is with the 'frmAddFinishedProduct' form and 'subfrmAddRecipe' subform. Thanks, Pam

=[RawMaterialPercent]*[LbsPerGal] is the formula on the subform (% of this ingredient times its density) and =Sum([RawMaterialPercent]*[LbsPerGal]) is the calculation on the subform. It doesn't seem to make any difference whether I view the record from the main form or open the subform by...

I'm sure this is going to be obvious, but right now I am stumped. I am also very new to Access and learning as I go. I am calculating a field on the subform, then using 'sum=' to adding them together on the subform footer. But the result ends up being the total of all of the subforms, not just...

I am working on a db for a chemical manufacturing business. We primarily want to be able to determine the cost of each recipe, and determine which finished products contain any given raw material (so that when there is a price increase, we can determine which products will be affected). We...