Search results

Another option would be to add the values from each field in the subreports to get a total in another subreport. Do you have any ideas on how I could do that? I tried adding the fields together, but I got a type error. I tried this...

I'm not sure that would work because sometimes the value in the field is blank, and other times it's 1, and other times it's X. If anyone else has any input, it would be greatly appreciated.

I can send the database. You have to open the MainMenu form, use Ann Smith, and hit Reports. It will default to week 12. Just hit Output. The report will pop up. From there, you can go into the design view and trace through the logic. My goal is to do some kind of cross-tab, but I need the...

Hello, I have run into a snag with my reporting. I have a complicated report that I can't seem to get to work the way I would like. I have a Daily Progress by Standard Action report that is made out of several subreports using the query qlkpStandardActionPoints query to pull data for each...

Ok, I got it. I already had them as a group, I didn't realize they had a value of 1, 2, 3. Thanks! Now I need to figure out how to save the report as a pdf to my computer.

Hi guys, I have three radio buttons (Screen, Print, PDF) that I am using to view, print, and save my reports. I am using nested if statements that look like this. If Me.txtReportName = "Week at a Glance" Then If Me.rdbScreen.Value = True Then DoCmd.OpenReport "rptWeekAtAGlance"...

I Thanks a bunch!

Nevermind, I was using the "Immediate Window" without using the ?

DCount("[ActionIDFK]", "tblActionsPerWeeklyPlan", "[WeeklyPlanIDFK] = " & Me.txtWeeklyPlanID & " AND [ActionIncluded] = True AND [ActionIDFK] = 3") Now I'm getting an = sign is expected

Hi guys, I'm a little rusty on the syntax for multiple criteria. I need the number of records that have the Plan ID of "Me.txtWeeklyPlanID" with the ActionIncluded = True and the ActionIDFK = 3 This is the code I use, but I get an "Expected list separator" error. DCount("[ActionIDFK]"...

I most certainly will. Thanks!

Thanks for the feedback, it helped me jog my brain a bit and I figured it out. I figured out the correct way to put it into a query. Heres the sql I ended up using in case you're curious. INSERT INTO tblFoodGroupsPerWeeklyPlan ( FoodGroupIDFK, [Index], WeeklyPlanIDFK, IncludedInDiet ) SELECT...

Hi CJ, Thanks for getting back so quickly. I am not getting an error, it's just not doing anything. I don't know how to use the debug. Print feature. I am using an on_click event to execute the sql. Here is the complete code for that event. Private Sub btnCopyPreviousWeeksGroups_Click()...

Hello everyone, I am hoping you might be of some help. I want to copy the records from the previous week into the same table, but with a different weekly Id. In my code I assigned the previous week to the "prevPlanID" and the current week to the "curWeeklyPlanID". Here is the SQL I used, but...

This information is great and much appreciated, but I was wanting to know why the validation rules and validation text weren't working and if one of the fields were empty, it didn't even save the record. Why would that happen?

Thanks guys. I'm not sure what happened. I must have messed around with something to fix it. Wish I knew what it was. I am having trouble with field validation. I'm used to using code to make up rules with an after-insert event, but I thought I could use validation rules with validation...

It is bound. In the properties section of the form, birthdate is used for the control source I can. When you open the database. If you open the main menu and click "add user", you will see the problem. When you go to type in the first name, the birthdate field fills with #Name?. I have a...

I edited my answer. The source is the actual user's table, and the control source of the birthdate field is the birthdate from the table.

The Users table and the birthdate field from that table is the control source. On the form the field is txtBirthdate.

Hi Guys, I added a new field "birthdate" to an existing table and form. When I go to add a new record using the form, the birthdate field fills in with "#Name?". I am stumped! Does anyone have any idea why this may be happening?