Search results

  1. C

    service record database design approach

    Ok, I couldn't get the requery to work but I found another somewhat crude method to accomplish what I want :). Now to figure out how to get those results and toss in a report.
  2. C

    service record database design approach

    That makes sense, but I'm unsure as far as how to check if the query has already been opened. I would assume you'd use some sort of "if" statement in the event code of the button I have created to run the query. Something like: if System History Query exists, then Me.System.Requery But I'm...
  3. C

    service record database design approach

    Ok. So I've setup a Form for the user to select the Customer and the System. I have linked that form to a query that retrieved all the results with the given information. My current issue is that after I query for the first time and try to query a different set of results, it does not work...
  4. C

    service record database design approach

    I'm trying to build a table structure for this database. Heres some background information about the business: The business is a service business. We visit the customer's location and run tests on whatever water systems they have. Each customer is unique in that they could have any...
Back
Top Bottom