Search results

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...

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"...

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 -...

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...

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...

I have a form with various controls that reflect dollar amounts. One of those controls, despite deleting and replacing it, despite deleting the field whose value it displays, despite changing it to 'general number', saving, then changing back, despite comparing its properties with that of...

I'm not sure what to search for to figure this one out. My searches, so far, haven't helped me much. I'm tracking transactions in a clinic. The amount due for the visit is calculated fine, but sometimes people don't pay right away. (And sometimes pay ahead, which will just be a negative amount...

I have a combo box with the following 4 columns: ItemID, Item_Name, Item_Cost and Taxable. The fields are Autonumbered, Text, Currency and Yes/No, respectively. I am trying to SUM sales tax, in the form footer, based on the Yes/No settings. Some items are taxed and some are not. So far, I am...

I have a form that currently adds services and products paid for by a client, via subform calculations, indicates payment, via cash, check or charge, and shows, finally, what is still owed. This is for a clinic and some old folks, for example, pay small amounts over time. The subtotal, sales...

I have a subform listing items for purchase. Some are services and are not taxable, some are products and are taxable. So far, I am calculating the sales tax for each record (item paid for), based on whether the thing is taxable or not and putting that result in a text box (txtSales_Tax) on the...

I'm creating an order form for a clinic. Health-related services are not charged sales tax, but products are. In order to have one subform to do the job (rather than one for non-taxable and one for taxable items), I'm trying to create separate running sums of taxable and not taxable items from...

I have a simple tabular form with the following: cboItem_Name txtItem_Cost txtQuantity txtExtended_Price The AfterUpdate for txtQuantity = Me!txtExtended_Price = Me!txtItem_Cost*Me!txtQuantity, which puts the extended price in the control. In the FOOTER of the form, I have txtSub_Total. It's...

I am making a simple tabular form to use as a subform in another. The form has a cbo box (cboItem_Name) Quantity (txtQuantity) Price (txtItem_Cost) Extended Price (txtExtended_Price) Selecting an item in the combo puts the price in txtItem_Cost. Default for Quantity is 1. Control Source for...

I have a combo box set up to select a product and put the price into a text box. I am getting the cost showing up in the text box Therapy_Cost just fine, but the combo box itself does not display anything after I select something. If I remove the AfterUpdate, I do get the item displaying in the...

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...

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 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...