Recent content by ClaraBarton

  1. C

    Select Case Textbox

    So you can't put a function in the click event?
  2. C

    Select Case Textbox

    This seems very simple but doesn't work. I have 4 textboxes with 4 buttons. When a button is clicked I want to copy the textbox content to another place. The code works if I place it in each click event but I'd like to combine the code into one function so I can add more. My problem is I can't...
  3. C

    make query updatable

    I'm using the transaction query on a continuous form. Fine. To get some calculations on a detail form I made the qryCatTotals. I want to know what is remaining after the transaction has been separated into categories. Check Amount less Category Amount = Remaining Amount. qryCatTotals has every...
  4. C

    make query updatable

    gotcha! thankyou
  5. C

    make query updatable

    I do. I've listened to you all enough... ;)
  6. C

    make query updatable

    OK, point taken. Thank you for explaining.
  7. C

    make query updatable

    yeah, probably.
  8. C

    make query updatable

    From everything I've read, if you need calculations, and you create them and then create a left join, the recordset should be updatable. This one isn't. Is there a way I can fix it so it is? This is the transaction query I'd like to have updateable: SELECT tblTransactions.fAccountID...
  9. C

    Solved Update a record with a recordset

    I do have a pop up form and that's where I go for categories, etc. But I wanted this option too.
  10. C

    Solved Update a record with a recordset

    THANK YOU, ARNELPG! So simple and so exactly what I need.
  11. C

    Solved Update a record with a recordset

    I have a continuous form that's a check register and the query behind it is not updatable. Double clicking in any field transfers the record fields to unbound fields in the header. I have saving a new record working but I'm a little lost on updating an existing record. How do I make sure the...
  12. C

    Solved Show transaction Information

    Great idea! I only need one textbox instead of two and I used the expression [Remaining] = 0 to fill it with gray and put it under my transparent button. Thank you so much!
  13. C

    Solved Show transaction Information

    I have a continuous form of transactions that has a button to open another form to split the transaction into different accounts. The transaction is completed when there is no amount remaining after the splits of the original amount. Each transaction has a field on the calling form showing the...
  14. C

    Does Dsum drag form down?

  15. C

    Does Dsum drag form down?

    Doesn't work. But I know it isn't right because I don't get the logic in self joins. Says the fields could come from either table. So I renamed the second table to SecondCheck but which fields do I use there?
Top Bottom