Forum Discussion

CletusK's avatar
CletusK
Copper Contributor
May 16, 2023

UNCHECK BALANCE ITEM FROM A BILL

How can I uncheck or exclude an item from the bill balances and grey it out when I am not supposed to pay for it in MS Access? Eg the bill on the form lists items likethis: Fish $200  Rice $100 B...
C
Kasenga
George_Hepworth's avatar
George_Hepworth
Silver Contributor
May 22, 2023
That's a bit confusing to me. I know it's excluding one item at a time because each item is a record and the record has the Boolean field indicating that item is to be paid or not. Isn't that what you want? What do you mean by "this procedure", if not?

The totals query would be set up to sum only checked items, or items with "Yes" in that field. So, what is different?
CletusK's avatar
CletusK
Copper Contributor
May 22, 2023

Thank you for your firm commitment to help me out.
As I said, I am getting the results depending on whether I select 'Yes' or 'No' after applying a query.
But my interest is on how, possibly, you get the values directly on a form when you click on the check box with/without filtering the Yes or No values with a query. As in the example I gave in my first question, say you have;
Item one: $100
Item two: $50
Item three: $25
Total: $175
Assuming all the values are set to Yes or no, how if I uncheck one Item do I get the total reduced directly on the form, nd when unchecked the item still appears on the form but only its value is not applied in the total? Is there some coding involved behind this work around?
I hope, may be, I have asked clearly now.

  • George_Hepworth's avatar
    George_Hepworth
    Silver Contributor
    May 24, 2023

    CletusK 

    First, my apology for the slow response. This forum has to be the least usable forum around. :sad:

     

    So, perhaps I didn't dig deep enough into the original problem. There are actually two different things going on it seems. One is the ability to check which items to include.

     

    The other is the calculation on the form showing the total of the values for "checked" items. That's the part I overlooked.

     

    How are you displaying that total on the form? Is it an expression in a control? Or, as I perhaps wrongly assumed, a calculation in the underlying query? If the former, there's one approach. If it's the latter, there is another approach that would work better. 

     

     

      • CletusK's avatar
        CletusK
        Copper Contributor
        May 26, 2023

        Thanks for your help. I think I've ill try to workaround the second approach and if I encounter any challenge, I'll ask the community again. Meanwhile I'll go through the file you sent and then I'll let you know of the outcome.

        Just a kindly request however, if you could send me a link to some of the most active forums,I'll greatly appreciate.

        Good day!