Search results

I have a form with combo boxes for selecting products to be purchased. When a product is selected, the price appears in a text box. This is working fine by making the bound column of the combo box the field containing the price. When I have two different products that have the same price...

Never mind - I did something I did before and this time it worked when it didn't last time.... I hate that.

Obvious neophyte issue here, sorry... I have a table, PURCHASE_ITEMS with 3 fields: ID, TYPE, NAME Another table, ITEM_TYPES with 2 fields: ID, TYPE TYPE in both tables is a text field and there is a one-to-many relationship between them. When I run a query on PURCHASE_ITEMS, I can see all 25...

I've twice gotten the following error message "The method you tried to invoke on an object failed" but had the code apparently work just fine anyway. How much should I worry about this? In both cases, it's making a simple calculation on the dollar amt in one box and showing the result in...

I've resolved it. Thanks to anyone who intended to help. Bound primary key to the combo and changed how the text box was populated.

Does anyone have another suggestion for this problem???

Thank you for the detailed response! I have changed my combo and text boxes to reflect your suggestions as closely as my table and box names allow. Let me give details. Table Name: Therapy Fields: TherapyID, Therapy_Type, Therapy_Cost Combo box Name: Therapy_Type Control Source...

OK, now I see why the specific selections aren't coming up. Their costs are the same. Wherever the cost is the same, the combo only allows selection of the first of the items. That is *weird*. On checking my other lists, I see the same thing is happening and I hadn't noticed it. This *ought*...

OK, I've found enough info on using DSum to probably get me going in the right direction.... so, never mind

I have a combo box in a form. The box is linked to a table called Therapy with 3 fields: TherapyID, Therapy_Type and Therapy_Cost. The table has been populated with 5 records: 1 Physical Therapy $125 2 Occupational Therapy $125 3 Acupuncture $90 4 Swedish Massage...

I am building an application for a small clinic. In the interests of good database design, I don't want to be storing numbers that are derived by calculation. A patient with insurance will have a deductable that will be entered into a field on their first (ms access) transaction form. A...

Okay, thanks... I get your drift now.

Thank you, Pat - I'm afraid I'm not quite clear enough. I'm bright, but very untrained. In your example, am I creating two new tables, or is tblItem one of my existing tables? Is tblItemType, therefor the parent table you mention? If so, I then have my combo box looking at tblItemType and...

I misspoke - I can create a query using the names of each type of item, but they come in one row, when I want them all in one column and, when selected, the price of each should populate a text field. I can get that to work, but, so far, only when using one table, since I haven't gotten all the...

I have a database with several tables that define types of products. Here are a few examples: Classes .....ClassID .....Name .....Date .....Time .....Location .....etc Products .....ProductID .....Name .....Manufacturer .....Price .....etc Gift Certificates .....GiftCertificateID .....Title...

God knows if anyone gets this far down the list....... This is either the best or the worst, depending.... you decide. An old man is in the hospital, visiting his wife who is dying. He's very upset, naturally. They're sitting holding hands and reminsicing and the wife hesitantly lets it come...

Never Mind.... I figured it out. The SQL version of IIf needed the syntax IIf(IsNull([FIELDNAME]), when the 'pure Access' version worked with IIf(IsNullFIELDNAME, Go figure..........

"Natural name format in combo list Thanks for the hint. I find that if I use the following SQL statement, I get every record listed, but only first and last name fields, of course. Since some contacts require more than those two fields, I can't leave it like that: SELECT Contacts.Prefix...

Hi - I'm very new and totally self-taught = ignorant. Sorry. I have a table called Contacts that includes the following name fields: Prefix First_Name MI Last_Name Suffix There is also a form called Contacts, where a user can input data on new people. On this form is a field called Full Name...