Search results

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.

Has anyone connected QuickBooks files to Access? If so, what did you use. I have Access 2019 and QuickBooks Accountant 2013. It looks like I would have to purchase an ODBC driver. Thanks

Those of us remember before this law that women were dying from illegal abortions. If the freaking liberals didn't demand free and late term abortions, this decision probably would have been left alone.

Well if Hawaii isn't in the US then Obama isn't American born and shouldn't have been president.