Search results

  1. A

    Happy Thanksgiving

    Happy Thanksgiving!
  2. A

    Associated Press

    And he didn't have to blow his campaign war chest on the elites for their endorsement.
  3. A

    Are Muslims and the Quran a threat to our society?

    No but we invested lots of money to support and educate her.
  4. A

    Are Muslims and the Quran a threat to our society?

    But we're only returning a defective item.
  5. A

    Associated Press

    Except if the accused is a conservative, then he's guilty.
  6. A

    Wasteful Spending

    If they did, a percentage of the savings would be worth it.
  7. A

    Creating a Running Balance Query

    It worker! I did try a function called FNBalance from another discussion but it didn't work because it didn't have the vba code. Thank you so much!
  8. A

    Creating a Running Balance Query

    Thanks. I will give it a try.
  9. A

    Creating a Running Balance Query

    Oops. I see you changed your response.
  10. A

    Creating a Running Balance Query

    FrmSelectRegister sends a filter when it opens form frmCheckRegister. Thanks
  11. A

    Creating a Running Balance Query

    Here's the DB. I converted text Account to AccountID. Thanks. I have two forms to select the checking account. frmBankAccounts is a bound main form with subfrmCheckRegister. frmSelectRegister has a combobox to select checking account and then opens form frmCheckRegister.
  12. A

    Getting Rid of the Electoral College Blight

    I sure wouldn't want this twit to be incharge of the US budget.
  13. A

    Creating a Running Balance Query

    Working on it.
  14. A

    Creating a Running Balance Query

    Yes
  15. A

    Creating a Running Balance Query

    I used Duane's version. My version gave the same amount on each record
  16. A

    Creating a Running Balance Query

    I get #Error on this.
  17. A

    Creating a Running Balance Query

    Imported by QuickBooks that way. I would have to convert it to use an autonumber
  18. A

    Creating a Running Balance Query

    Thanks but I did try it without the quotes before ID (at least I think I did)
  19. A

    Creating a Running Balance Query

    OK, I'm stuck on stupid here. This is the code behind the subform field (I did try several different variations): =Val(DSum("Nz(Debit,0)-Nz(Credit,0)","qryCheckRegister","[Account] = '" & [Forms]![frmBankAccounts]![Account] & "'" And "ID<=" & [ID])) To recap, frmBankAccounts is the main form...
  20. A

    Add new foreign ID to record

    I've just imported transactions from QuickBooks to do this. When there are more than one offsetting entry, the Account says "-Split-" and QB expands the form so you can enter them and then creates the transactions. They must use a foreign key to tie them in for reporting purposes. I haven't...
Back
Top Bottom