Search results

  1. D

    Increment date: previous date +1 ?

    Very simple question: I just moved a simple daily rainfall record spreadsheet to my Access gardening database. Fields are date, rainfall in mm, temperature etc. and a single record is added for each day. How do I get the date field to increment automatically to 'previous day's date +1'. (No, I...
  2. D

    How to allocate half values of shared objects

    We have many widgets. Each is owned by A, or by B, or jointly (& equally) by A and B. Every widget has a financial value. How do I produce a report listing all widgets & their values, sorted by value accrueing to each of A and to B? A's assets would = sum of all 'A' widgets + 0.5 value of all...
  3. D

    NotInList Requery fails in a macro

    I have applied the NotInList event of a combo in a data entry subform, to activate a macro that opens another data entry form. This allows the user to enter the item missing from the drop-down list. The macro's next item is Requery but it is not updating the first form: I have to do this...
Back
Top Bottom