Recent content by JamesJoey

Ok. I've been checking out some of these calendars and I believe it's what I'm looking for. Thanks much

I wanted a calendar that I don't need to click something to open. Just want it on a form. I have several forms with date/time fields which utilize the date picker. That's not what I want.

I'm really not looking for a date picker. Just a display calendar.

Hi. I'm trying to find a calendar that I can place on my form for viewing only, with the ability to change months. I've been looking but haven't had any luck. Thanks, James

It's not really copying the last entered value, it's the $10 that was entered for "John Doe" I might have an entry for; say my gas company payment that's $80. Or my electric bill which might be $70... Let's forget it. I never said anything about "Moving" a record. I know what a slit form is...

It's not really copying the last entered value, it's the $10 that was entered for "John Doe" I might have an entry for; say my gas company payment that's $80. Or my electric bill which might be $70...

The currency value will be different for different payees. And I do want to add or delete payees from tblPayees.

Ok. I'll try to explain this one more time. You have a split form. Split form has rows and columns. Right?? Split form has 3 columns: 'Payee' 'Debit' Credit.' Lets say there is no data at all being displayed in the spit form. This is where it gets tricky. Lets say I type "John Doe" in the...

OK. Then how do I get it to enter the data for me?

I'm typing in the values myself. That's the purpose of my wanting to auto-fill these.

I guess you didn't understand #16. Obviously since Debit and Credit are Currency fields they would be populated by currency values.

I posted the structure of the 2 tables. I want to autofill the Debit and Credit fields when I select a Payee from a Combobox.

Is there a join wizard? Not sure how to create one. Do I need to modify the current qry?

So I need to add a Debit and Credit field to tblPayees?

I have a Debit and a Credit because I don't have to remember to place a negative sign in front of the Debit value. Although I don't have Debit and Credit fields in tblPayees, only in tblFincnaces,