Search results

I gotta tell ya... I spent several months messing with my transfers and categories. Never quite right. I just spent 2 days going back to accounts with debits and credits. It works EXACTLY RIGHT! I thought you all weren't paying attention but you knew your stuff. Thank you so much for your help!

See... back to my junction table tblPost :cool:

I like Mark's best... Transaction to Post (one to many), Post to Account (one to one). 2 foreign keys in Post (transaction and account). Data Entry form: balance sheet accounts with sub form being Post amounts with combo for account. Am I right?

Slept on it. You are right and I should have known better. I've spent a year trying to make it work and I was picking up Quicken traits because I imported years worth of transactions from there. Somehow it didn't click that my personal stuff is no different from business. I'm rebuilding my chart...

Sheesh! You guys are making me rethink my whole system...

Transfers neither spend or accrue monies they just go from account to account. Cash to Checking. Checking to Charge Card. Asset to Asset. Asset to Liabiility. Paying out or bringing in (non-transfers) is receiving or disbursing monies. Buying Groceries. Receiving a paycheck. paying the...

OK... close. I have the details worked out and they have been working for a long time. I just was not happy with the way I transferred amounts. Most things go into expense accounts (categories). But paying the Costco bill out of Cash. Depositing checks to Checking out of Undeposited. Drawing...

I do have all these amounts. That is the route I'm following. They are input on the form. The subform is following the same route but should tie the two together and then I use sql to add the second junction. (to tie the subform transaction to the form transaction when the opposite account is...

Not emulating Quicken but generally accepted accounting principles. Regardless, it's still self-referencing tables with a bridge. Actually, Quicken shows them as categories along with groceries and utilities.

I'm an accountant. I get that. And that's the way it works. I just can't figure how to get my form to post correctly.

The tblTransactions has many more fields than shown and I actually need 2 complete transactions for each account. I started as you suggested and thought this seemed much more right. I just want to connect the two transactions to each other.

I have a table of transactions. When I transfer money from one account to another I need 2 transactions: debit to one account and credit to the other. After Much Much messing I've decided I need a self-referencing table with a bridge between them Everything I've read says I need a subform with...

got it! Thanks.

that's a good idea. I have to research combined field indexes.

I have a nursery... Lanes (Rows) of trees, spaces (holes) for each tree. Each Tree has an address 34:125 or 17:62 (Lane:Space).. This has worked well for many years. Suddenly we asked the daughter to do data entry. She added duplicate addresses. My fault so I'm reworking the back end. Should...

@arnelgp stupid question... set lst = VisibleList(me.name) set lst = VisibleList me.name set lst = VisibleList (popUsedBy) set lst = VisibleList ("popUsedBy") Seriously! nothing compiles

Thank you so much!!!

way overcomplicating my question. All I'm trying to do is figure which listbox is visible and then grab that for other events. What I'm struggling with is calling the above function. I've figured out I need to make it a string Public Function VisibleList(frm As Form) a string If...

The reason I need to specify a specific listbox is because I requery it from another form, I do multiple selections from them, I move items in it. I thought this was the "smart" code, to make one function work for multiple places. Function GetList() On Error GoTo Err_GetList Dim i...

"codpiece"? Way more than I needed....