Search results

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

The NEXT button on the main form?

May I hijack this discussion for my question? I have more than one checking account. When the first account is displayed, then it's displayed correctly. I have a main form, frmBankAccounts, bound to qryBankAccounts which displays all back accounts. The subform, subfrmCheckRegister is bound...

Thanks for your thoughts. My version of QB, 2013, has limited exporting. The Vendor and Customer lists have a direct to Excel. The Transactions are a report which requires a lot of editing, etc. I will check into OFX. I don't remember seeing it. Thanks

Agreed 100%

This from a liberal site. https://www.snopes.com/fact-check/trump-and-children-face-250-million-tax-evasion-charges/

Thanks George

Actually they do have a QBD version. You have to search their site. It's 250 pounds per year.

Thanks. That's for QBO. I don't know why it doesn't work for QBD.