Search results

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.

I used the function in the query and it worked for loop 1 but not for loop two. Funny thing is that if I just put the number 2 in the criteria for the query it works. Not sure why this is so difficult to obtain.

So I'll try to explain this better. I have some reports that I need by the loop (12-week cycle). I have a form where you can select which loop you want. I have a function tied to the combo box where the loop number is which is being pulled from a table. Here is the function I used. Function...

Thanks, but bastanu's suggestion did the trick.

Thanks a bunch, that was easy.