Search results

  1. P

    When is an empty field in a table not really empty?

    I have a DAO recordset query which I am running against a table that a user can change. The query looks at one particular column in the table and if a field is blank, it pulls data into that field from another table. This all works fine except when a user deletes data from that column. The...
  2. P

    Can VBA code run when user changes records?

    I've been trying unsuccessfully to find a way to have some VB code run when ever the user presses the arrow buttons at the bottom of a form to move to the next (or previous) records. All I have been able to implement is something that runs when the user moves the mouse over the detail space or...
  3. P

    How do you do a sumif in Access, similar to excel?

    I'm trying to add a column to my make-table query that will give me the sum total of all rows in the source table which have a matching property. For example all my orders have multiple lines and I'd like to have this column search the entire table for all the matching orders and then put the...
Back
Top Bottom