Search results

Thanks - I'll check again. I'm at the beginning stages of the DB so it's not too late to make any corrections.

Good afternoon and Happy New Year! I am working on a hotel project and created a continuous form listing all the tasks that need to be completed for the guestrooms with a Yes/No field. Each room will have the same tasks. I would like this form to be a subform where the main form will have...

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