Search results

Thanks, Banana.... I've apparently resolved my problem through a combination of using a query and blasting past a blind spot in my mind regarding correct syntax to use in a Control Source. If I don't come whining back, then I'm squared away.

Thanks, Banana.... Like many rank novices, I've leapt over the most basic things, done some stuff that works, but find myself at a loss over the simplest things. I can create a query that pulls the data I want and make it the RecordSource for my form. This query, built with the wizard, is not...

OK, I am getting hints... So far, creating a query using the wizard, I can either leave it a SELECT and make it the RecordSource, or make it Updatable and it won't let me make it the RecordSource. I gather that mostly means I need to know more of what I'm doing. Pat, a lot of the controls on...

OK... and the fact that I'm using a query for this won't impact the addition of new records, then? Seems to me I've read a number of comments on the forum about using queries so data in tables doesn't get inadvertently altered.

LOL OMFG!!! All I can say is, Duhhh......

Pat - Can you clarify? Do you mean use a query for the combo box that joins the two tables, or in the Control Source of the text boxes? If the former, I think that's what I'm doing. Maybe I'm just not doing 'enough'... If the latter, would that look at the selected name in the combo box and...

I have a simple database application where the programmer has the same code in two locations to do the same thing, depending which event happens. I'd like to turn that code into a function and call it instead, so it's only present one time. The two instances start: Private Sub...

RV - Yes, the combo is a bound control, but the four others are not, since the information's coming from a different table than my record source. AfterUpdate of the combo just places it in the form. Quicksilver's answer sounds like it should work. Quick, this happens either when I scroll to...

NikToo I've just done basically the same thing. Have your combo box based on a query that pulls the drug name, it's unique ID (autonumber, probly) and the cost. Bind the combo to the ID column (remembering that Access, in this instance, numbers the 1st column zero, not one). Make the ID column...

I have a form where the user selects a client from a combo box. Doing so populates 4 controls with info about the client, using the Exit function of the cbo box. The Record Source of the form in question does not store this info; it comes from a different table. This works fine. When the...

I have a little application that includes information about insurance deductables. Deductables revert to their maximum on a date set by the insurance company, but that is USUALLY January 1. So, for the control on the form where a new patient is set up, I have a date field where that "revert"...

Thanks, Pat....... another of the millions of pieces of information I didn't have has been put in place. I'll start looking into subreports.

Hi, all... welcome back to the new Access World Forums... glad we're still operational, even if some data was lost. It's the minds, anyway, not the data... I have a query that pulls from 3 transaction tables. tblTransactions - lists purchaser, amt tendered, other details tblPurchased_Items -...

You're right, Scott, about DSUM needing to be applied only to a field or column. I'd misread the help screen. It says you can *include* a control on a form in <expr>. I'd misread that to mean it can refer to a control. I know I need criteria for what I'm trying to do. I meant, in attempting...

Thanks, Scott - I've tried your suggestion and am getting the #Name? error, so it looks like the way I'm referring to my controls is wrong. According to the Access help files, DSUM's "[expression]" can refer to a field in a table or a control on a form, while "domain" can only refer to a...

Scott - You misunderstood me. I'm not storing the calculated value. What is being stored is the INITIAL value, as set by each person's insurer, and which may change if the policy changes. I'm wanting a running calculation of the remaining deductable, as I said. Thanks for the pointer. I'll see...

I'm building a form for a clinic. Insured patients have deductables and copays that usually reset on January 1st. To be clear, a deductable of $500 is reduced each time the patient pays, but jumps back to $500 at the beginning of the next year. The table containing patient records has a...

Thanks, Pat, for that reminder. I somehow hadn't seen my subform listed in the Tab Order list, otherwise I'd not have asked the question. But your comment brings up another question: If the subform is, for example, where items to be purchased are listed, amount tendered, which is on the...

Thanks, Larry - Since this text box HAD been working correctly, I decided it had developed some form of internal corruption. I copied and pasted the corresponding box from an older iteration of the developing form and the copied box worked correctly. Then deleted the bad one and continued on my...

Is it possible to set the Tab Order to move to a subform before all the controls in the Main form have been passed through, and then come back to the Main form where one left off? I have a form with a client name and a chargable service, a subform with products and, on the main form again...