Search results

I am printing out the daily meal plans and in the footer, the client writes in what they actually ate. It's empty data and nothing to group or sort in the footer. Here is a screenshot that might help. Most of the time it will fit, but I'm worried about them not having enough room to write...

I have a report and if the detailed section fills the page, I want to put what's in the footer on a separate page. Is that possible?

I don't know what happen, but I went into the crosstab queries and added [Forms]![frmSelectLoopReport]![cboLoop] into the criteria. It created another column in the query that just had the WHERE for the loop and now it seems to be working. Sorry, I'm not sure what I did before but it's working...

The query "qrptReversalDietByWeek_Personal_Rationed_Crosstab" had a 2 in the criteria, The criteria needs to be added on all the subreports for whatever is selected in the list box. I have tried everything. The heading might say 2 on the report but the data does not reflect it. There should...

I first had it as a list box and changed it to a combo and when it didn't work, I turned it back to a list box. Forgot to change the lable.

Ok, so after struggling with this for way too long, I will attach the database to see if this problem can get solved. There is really a lot to this program. To get to the report I'm talking about open the Main menu form and choose John Jones. He is the only one that has data for both loops...

What about the "Date: DateAdd("d",D,[MealDate])"? How would I use the "D" variable in the sql?

Yes, the box turns red when the item is selected.

Hello, I'm trying something that is a bit difficult but will be worth it if it works. I need to copy records from the table "tblMealcomponentsPerWeeklyPlan" with the "WeeklyPlanIDFK"=Tempvars!TempPlanID and the "DOW"=1. When inserting the records I need to add a day to the date "Date...

Not tonight though. Off to bed for me. Thanks again for everything.

didn't work either. I just realized that "lngUserID is used as a parameter in a function. I should be just glngUserID, I tried it with that and it still didnt' work. Taking a break for tonight. I'll be back at it tomorrow. Thanks!

Thanks, I will look at it.

I just tried and it fits without any deleting. It's not nearly as big as the first version and it does a lot more. I took all the advise on here and redesigned it. I have another question out there about filtering subreports. I will upload the db on that one. Thanks for everything.

There you go.

I was hoping to avoid that, but I'll try to take out what's not necessary and see if I can get it small enough. What is the max size limit for sending files?

Same error. Not sure what's going on with this one.

I tried that and still didn't work. Getting a syntax error (missing operator) in query expression '[UserIDFK] = AND [StatusFK] <> ' DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & status)

Can anyone see what I'm doing wrong with this one? DCount("[WeeklyPlanID]", "tblWeeklyPlans", "[UserIDFK] = " & lngUserID & " AND [StatusFK] <> " & 'New') I tried the New in double-quotes too.