Search results

  1. K

    vba SQL query: <> condition ignored in WHERE clause

    Hi, Maybe this is a stupid question, but I think this should be pretty straight forward. I have some rows in a table, and I want to select all of the rows that matches an given criteria and does NOT match another. So far I have SELECT field1...fieldN FROM table WHERE [employeeId] = '" &...
  2. K

    Automatically re-size query result part of form?

    Hi, I have created a form that uses a query as a Record Source and displays the results in a Columnar format. However, there is a lot of "wasted space" between the last record and the bottom of the form; is there a way to have this part of the form sized automatically to fit the number of...
  3. K

    How to update a field when another field is updated?

    Hi all, I have a form that is setup to display in data sheet view records returned from a query. Lets say there are two fields, called "QuantityMade" and "StopTime." I want the "StopTime" field to be updated to the value Now() when the "QuantityMade" field is updated. I first thought to...
Top Bottom