Search results

Thank you! Exactly what I needed!

ok! on the same page! So... using after update to assign the control Source? and leave it blank in the properties? Will that work?

yeah. Actually, I've been an accountant for years. I get all this. The only reason I mentioned Quicken is because they list the accounts with the categories and split the money so. Accounts are a TRANSFER type and enclosed in brackets and Categories are either EXPENSE or INCOME type. I'll move...

I am not reusing controls. Money can be spent and categorized or moved to another account. How would you assign a check?

Accounts do not have categories. Accounts are Checking, ChargeCards, Cash, Undeposited, etc and have many transactions. Transactions are divided into categories.

Yeah, I've been using it for some time too for small business and personal finances and I really like it but the time killer is every time I use it I think of something that might make it better and then waste half a day to save a few seconds. I'd love to see your program. I use mine for...

point taken. many times here. suffer me anyway.

Sometimes a checking transaction gets split into categories, food, shelter, etc. But sometimes you want to transfer money to a different account, make an atm withdrawal which goes into the cash account. Checks are taking money out. Withdrawals just move it around. Either way, you need to put it...

I have a combo box with 3 rowsource fields (ID, Category, Type) that I want 2 control sources. If a selection is made for a category type, the control source is the fCatetoryID. If the selection is an account type the control source is TAcct (transfer account). I made an If, then function...

Got it fixed. Thank you all.

Well! Checking the PK works great! Why doesn't the other work? Thank you very much. DBguy... since it's on the load event how would that be possible?

I'm calling a detail form from a list form. Usually the detail form is called with a where condition and goes to that record. However, I also have a New button that calls the detail form in datamode:=acformadd. To add a new record there are a couple routines I need to run first, so on load : If...

ok... watched the video. I'll rethink my form. Thank you for all your help.

Ok... I had it set up with unbound controls first but I saw this code and it looked like just what I wanted. I've added a sample if you want to look at it. Click on Transactions on the opening menu

Why would that work? Wouldn't that require a button? I want it to always be this way... that's why I though current would work.

No. I want the all records from the account on the form but to show the most recent 19 (available landscape) records with the new record to be added at the bottom (ascending). Or maybe descending...whatever. Sorting the query in ascending order leaves the form empty except for the last record...

I want it to always be that way, so if I filter the form, or edit a previous record, or add a new record, go back to this way. Current cannot work.

I want to show the last rows in a continuous form and enter new transactions at the bottom... like Quicken.