Search results

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?

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,

The only link between tblPayees and tblFinances is the Payee. I have PayName in tblPayees and the Payee field inn tblFinances. I simply select a PayeeName from the combo box and it gets stored in Payee in tblFinances. The credit and debit fields are in tblFinances.

No. The combo box is populated by tblPayees which has on 2 fields PayeeID and PayeeName

I have a table which similar to a checking registry. I also have a Payee field in my 'tblPayees' table which I use to autofill a Payee field via split form's combo box, in a checking table tblFinances. tblFinances also has 2 other fields Credit and Debit. I want to be able to auto-fill the...