Search results

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?

That wouldn't help, The report is only for a single week. I probably need to create another group, but everything in the footer is just text and not bound to anything. It's kind of like scrap paper for the client.

I just tried using the report header, the problem is that it goes through all 7 days and then prints the footer. I need it to print after each day. I tried forcing pages before and after, but now the report starts with a blank page and displays the 7 days and then the report footer.

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...