Recent content by JamesJoey

I used the wizard to create the main form and the datasheet subform. But the datasheet subform only returns 1 record. The wizard used the ID field in the Link Master Fields and Link Child Fields.

Some time I like to change the font name of my split form datasheets. I thought I found an easy wat by selecting 'Options'>'Datasheet'>'Default font' But I find there is no option for the font name, only Size, Weight, Underline and Italic. Currently I'm changing the font by using: Public...

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?