Search results

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?

I already have a DOW group, I added a footer to that and it works great. Thanks!

Ok, but it's going to put the "Specific Meal Plan" data after every meal. I need it after all the meals are displayed.

Here ya go. I attached the design view and the first three pages of the report.

That puts a new page for every record in the group. How do I put a page break after all the records in that group are displayed?