Search results

  1. J

    Dropdown List values different from bound field values

    I'm guessing using the dropdown and a bound textbox and an afterupdate event ?
  2. J

    Dropdown List values different from bound field values

    I have a dropdown that lists employees but only active employees (where inactive=FALSE). The dropdown is also bound to a table that stores the employeeID per record and has historical data (Inactive=TRUE or FALSE.) I am seeing that when an employee is set to false, it doesnt show in the...
  3. J

    Solved Cumulative total in Textbox

    User is storing hours worked and instead of having to calculate and update the field manually, they want to enter the data to be added in the field and have it update the total automatically. Not alot of space to put another textbox for data to be added I figured out a work around
  4. J

    Solved Cumulative total in Textbox

    I am looking do a calculation when data is entered in a textbox. It should add the current value of the textbox + the entered value and store the new total. Doesnt seem like I can use BeforeUpdate event to do the addition and textbox.OldValue field doesnt always have the current value?
  5. J

    DISTINCT values of a Subform Recordset

    Is it possible to take a RecordsetClone of a subform(filtered) and then in VBA, query on the distinct values of that recordset? -------------------------------------------------------------------------------------- Set rs_Clone =Me.subfrm.Form.RecordsetClone /**Set another recordset (rs_Cust)...
  6. J

    Tab Order through Subforms

    Using LostFocus() or Exit() seems to work for forward tab order. I would need to add the programming if I wanted to do reverse tab order, but I've seen the code that works
  7. J

    Tab Order through Subforms

    I have a main form that has 5 subforms with text controls and in those subforms , there are subforms with text boxes. The main form has 8 text boxes that have tab order 0-7, then the first subfrm1 has two text boxes then a subform(1.1) with three textboxes I need to go from: MainForm.textbox7...
  8. J

    Saving a form with subform

    I did it in the subform Before Insert and it seems to work
  9. J

    Saving a form with subform

    Which form event should I set the variable in?
  10. J

    Saving a form with subform

    I have a form that has a subform (subform1) and a subform (subform2) in that. The data is entered in the subform2, but I need subform1 to save a record as well. I default a textbox to the ID I need to save, but it wont save because I dont enter any data in that form. What is the call I need to...
  11. J

    Limit Subform to one record

    I'm running into an issue where if I create a new parent record, this logic isnt working because I use the link master/child field property in Access, so the recordset may be 1, but for that parent record it is 0. Could I update the code to account for this second filter?
  12. J

    Field with calculation and control source

    I agree that Duration, as a calculation, should just be an output and not stored in the DB. Thank you for the clarification
  13. J

    Field with calculation and control source

    I have a field in a subform that I need to have as a calculated field but also stored in the database. I have a table with Start Date, End Date and Duration In the sub form(s) I would need the duration to be a calculation of WorkDays(startdate, enddate) and the next subform (With same fields)...
  14. J

    Limit Subform to one record

    Great Stuff. Thank you
  15. J

    Limit Subform to one record

    I am assuming I put this on Form_Load() event?
  16. J

    Limit Subform to one record

    I have a subform that has three fields - Start Date, End Date and Duration. It comes from a table that has many records, so the recordset is Select Top 1 (although there should only be one). This subform should be able to allow for new entries, but just one, so I have to set the Allow...
  17. J

    Solved Filtering form and subform

    I think I wouldve needed to do the filtering with SQL in code to get it to work. I found a workaround by updating the form recordsource based on a subquery of the subform recordsource.
  18. J

    Solved Filtering form and subform

    The Main screen is for Treatments/ORders and the filters are all based on filtering the Treatments (Orders). Each treatment/order has one customer and multiple products (shown using the subform on the treatment/order screen). They would use the product dropdown to show all treatments/orders...
  19. J

    Solved Filtering form and subform

    This is the main form A treatment has one customer, one disease and one season. It can have multiple species and multiple products. The users can filter up top by customer, disease and season to narrow the records in the recordset. They also want to filter by product, showing the treatments...
  20. J

    Solved Filtering form and subform

    This is what I tried, but when I filter the subform, I need the main form to filter based on that. So for example, the main form is orders and the subform is products for that order. Orders table ID Order No CustomerID StatusID Order_Product table ID OrderID ProductID Product Table ID PRoduct...
Top Bottom