Search results

  1. G

    Quick Warning To Users When A Field Is Left Empty

    Hi all. I've got a form with combo box the main form and also have a subform. The combo box stores a numerical "ID" of the control whilst displays the text value. I was just wanting a simple messagebox when someone enters data in one of the fields in the subform and the user has forgotten to...
  2. G

    AfterUpdate Code on form

    Hi all, I have a form with two subforms on it. Both subforms have a "total" summation in the footer section of each form. On the second form, when a user updates the quantity for a line item, I currently have some code on the 'AfterUpdate' property of the 'Quantity' control, which should check...
  3. G

    Solved Correct Way Of Referring To A Subform Control

    Hi guys, I've got a form with two subforms on it. (The form's name is "PrepOrders" in case this info is required) I'm not sure (even after reading and watching a few demo's) how to correctly refer to one of the subforms control? I have this code: If Me.AllocatedTotal >...
  4. G

    Disallow A User From Over Allocating Available Stock

    Hi all, I've got a database which records purchases and sales. What I'm trying to do is if say we have 20 Units of Product A available, to stop a user from accidently entering anything over 20 sales of Product A. The same should be applied for Product B, C etc. I've been unsuccessful for a...
  5. G

    Solved Updating Fields Automatically On A Continuous Form

    Hello all, I have a Combo box (ProductName) on a continuous form (this form will be used as a subform) and what I was trying to do, was when the user updates/selects a Product, the respective UPC, Size and Variety fields will automatically populate for that line item. I'm not sure how to...
  6. G

    Get the information from subform to populate a table entry in the main form

    Hi all, I have a form with a couple of subforms on it. These subforms have a summed total amount which I want to populate an entry in the main forms table. For example, let's say each subform on the main form contained a summed total for Widget A amount (on subform 1), Widget B amount (subform...
  7. G

    Solved Perhaps Ghosts Are In My Database!

    Hi all, I seem to have multiple problems with my new local Access database (Access 2010) with behavior's I can't explain. My main problem right now is that for the strangest reason, I can't even copy and paste a copy of an existing form (I've tried to do to use for testing purposes to find...
  8. G

    Main Form Combobox to Filter Subform Results

    Hi all, I've got a combo box on a form and after the user selects something, I want the corresponding details on the subform, but I'm getting a reference error in the After Event Code. I've been trying to follow this example...
  9. G

    Using IIF and 'And' statement in Form

    Hello all, I've been working on an IIF statement on one of the controls on my form and for over 4 days I can't seem to figure it out- so I thought it's time to reach out for some fresh minds and ideas. :) Happy to provide more information if required, but I didn't want to bored people with...
  10. G

    Selecting New Record On Form Not Automatically Recalculating Fields

    Hi all, I have a form with a couple of simple fees. One of these is a 'basic fee' which applies to all records. I have put a default value in this field for any new records created (let's for example say it was $1). Then there's an 'Additional Fee' for example, where the user would have to...
  11. G

    Query Returns Applicable Price Based on User Criteria

    Hello everyone, I haven't really used Access much in over 10 years. I used to use some of it's basic functionality (minus programming) for years. But now I'm super rusty and have been mulling over this for over 2 days and still blank, so thought I might ask for some input please. :) So it's...
Top Bottom