Search results

Upon further thought, I'm going to move in another direction. I don't feel right bothering you all with this. No need to dig any further. Thank you kindly for what you've done to date!

Yet your report differs from the original - your report works (by not cutting off at the bottom of the first page and continuing onto the next page). I want to use it, but I can't unless I can duplicate what you did (onto my original). I hate to belabor this - but if you can remember what you...

Still trying to narrow down where the changes were made. Have discovered that it must be in the main report, as I copied over each of the three reports (one main and two subreports) individually and the change occurred in the main report. However, still haven't found what it is . . . Gosh, I...

There is a page break on the main report R_Recipes located after the subreports in the detail section; and a page break on sub report R_Recipes_Checks subreport on the report footer; there is no page break on the other sub report. These page breaks are not new (they are on the original db)...

This works - as in when there are many ingredient entries the list continues on the next page; and the QC Checks continue to hide if other than "major"; and the report groups on the type (i.e. Major). I have searched the report and subreports properties and underlying queries (comparing your...

I posted here previously on another matter (hiding a subreport, if) and that was resolved. The issue I now have is on the same report (but a different issue). The QCcheck subreport is cut off the main report when the ingredient list is too long. I've tried so many different combinations of Can...

Oh my gosh!!! It does work!!!! I don't know what I did wrong before, but I am thankful that it's working now. Thank you (to you both)!

I made a copy of the db, stripping it down. I think everything you need is included. (By the way, I did try doing what arnelgp suggested, but the subreport was not visible on ALL reports - even "major"). Thank you for your help!

Reading over your previous message, please note that recipes have multiple ingredients and those ingredients have one sub type (i.e. "major" or other) and not more than one.

Here's the report; I'll get the other stuff you need too.

Yes, I will do that. I need to enter some dummy info first. These need to be jpg or pdf?

Doing this is making the subreport not visible even if "major" type. I think I have to go back to the drawing board on this one. The main report has a text field to show the type from the ingredient subreport and I'm trying to hide the other subreport based on this. Anyway, I don't even know...

Thank you for the response, unfortunately I can't do that because I have check off boxes and some other formatting on the sub report.

I placed this on the Main report, On Print event; but get an error ("Compile error") Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Me.child.[Report]![R_Recipes_Checks subreport].Visible = Me.[txtRecipeMix] = "major" End Sub

Hello, I will try my best to explain. I have a main Recipe report that contains two sub reports (one sub report contains the list of ingredients needed, and the other sub report contains the QC checks needed for the recipe). Both of these are linked to the main report with parent/child...

Access 2007: on Data Entry Form, this is what I hope to accomplish: If I choose [90ft Line] from ComboBox on main form, then limit my choices on Items Subform ComboBox to include only those items from [90ft Line table]; OR if I choose [80ft Line] from ComboBox on Main form, then limit my...

Thank you. But this doesn't give me what I' looking for. I have the same item number that can be run on different lines (2 primary keys). I want the production standard to show up on my report as the 'highest number available' regardless of what is entered in the field. There is more than one...

(Running Access 2007; limited understanding; trying to pull data together for a report) My dilemma: I have an Item# that has a production standard that may differ based on how the production line is run - (i.e. Item 1234 Prod Std 5; Item 1234 Prod Std 3 and so on). There is a production...

YES! Thank you Brian. This works!! AdjTotal: (IIf([ProdBatch_Type] Like 'Batter*',[ProdBatch_Weight]*[ProdBatch_Number_Batches]*0.9,IIf([ProdBatch_Type]="donut",[ProdBatch_Weight]*[ProdBatch_Number_Batches]*1.31,[ProdBatch_Weight]*[ProdBatch_Number_Batches]))