Search results

Hello, So the [txtTTLInsurable] is in the Month group footer. I also used the same formula in the Report footer. What I don't have is any sub-totals in the Quarter group footer. As I run the report for one quarter at a time, I didn't use the Quarter group footer, only the Month group footer...

Thank you

So I found a work around which is giving me the correct total, I'm just wondering if it's the best solution. In the report footer I calculated the grand total for the total insurable and named the text box GTInsurable. Then to calculate the total insurance payable per quarter I created a text...

When I try to run the report with the expression to sum the insurance, a box pops up asking to Enter the Parameter Values for the text box txtTTLInsurable. That is the text box in the Month group footer.

Good Afternoon, I am trying to sum a calculated control in a report footer but not having any luck. This is a quarterly report that calculates the insurance payable per month within the quarter based on a set percentage per invoice. Note, the insurance payable is not calculated per invoice but...

@CJ_London Thank you for your help even after as @Gasman rightfully said I left in a huff. Please accept my apologies but I can't help but feel slightly embarrassed when I don't fully understand. I am self-taught and although I have been using Access for years I still consider myself a...

I'm sorry for not acknowledging the individual post; I did however, thank everyone for their assistance in post #22. I really do appreciate everyone's help but I guess my beginner status is an irritant as this is the second time I have been admonished on this website for not understanding. My...

Yes I did but unfortunately I didn't fully understand it. I'll try again to go through it to see if I can figure out what to do. In the meantime, I have attached a .gif to show what is happening

HI, By formatting it I meant just making the form look "pretty" - add colour, form headers, adjust font, etc. I added the event on the GotFocus but still having issues. The first picture is what I was seeing when I first opened the form (before adding the GotFocus) event Now the product...

My form stopped working again. It was working perfectly and all I did was format it and now everytime i open it the cboCategory parameter box pops up. What am I doing wrong?? 😩

With everyone's help and through trial and error (several trials and errors) I think I finally got it fixed. This is what I have for combo cboProduct. Control Source: ProductID Row source: as below SELECT tblProducts.ProductID, tblProducts.ProductName FROM tblProducts WHERE...

Ok...so I'm still getting a couple problems. I've tried both @MajP and @bob fitz methods and getting the same error message when I try to tab to a new record in the subform. A message box pops up which states You cannot add or change a record because a related record is required in table...

Yes...thank you. This seems to have solved my problem

This works...thank you so much

Hi. I did. Still didn't work.

If I open the subform frmMaterialRequisitionDtls alone, the combo boxes work. But when I open the frmMaterialRequisitions, the combo boxes do not work

I'm starting to think there is a problem with my Access program itself. Another database I have been using for over a year now, started giving trouble after an update in April.

I don't understand why but it's just not working. This time the Enter Parameter Value keeps popping up everytime I open the form

Good Morning, I would really appreciate assistance as I have been trying for over 2 weeks to get the relational combo boxes to work. I am trying to set up a Material Requisition DB. In the details section of the subform I tried to create a category combo box, which when a selection is made...

Thank you! When I check the version history I see there was an update on April 11th which is probably what caused the issue; and an update on April 25th. I just did the April 25th update hoping it was a bug fix but no luck. So I will try restoring the version before April 11th to see if that...