Search results

Happy Thanksgiving Doc. The other day, hubby smoked our turkey, it was awesome. Your method of cooking a turkey sounds interesting.

Happy Thanksgiving!

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

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

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

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!

Thanks. I will give it a try.

Oops. I see you changed your response.

FrmSelectRegister sends a filter when it opens form frmCheckRegister. Thanks

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.

Working on it.

Yes

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

I get #Error on this.

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

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

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...

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...

Ok thanks

This isn't always feasible. Sometimes you will have multiple entries. For example: Date. Check No. Amt 11/10/24 292. 500 credit Checking Acct 11/10/24 292. 200 debit Rent 11/10/24 292. 300 debit Security Deposit