Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lrmac93

    evaluating null record sets

    tman, that's worked a treat. thanx for the help lrmac93
  2. lrmac93

    evaluating null record sets

    i've tried your suggestion and although the message box appears when there is no records, the empty form still appears after you close down the message box.
  3. lrmac93

    evaluating null record sets

    i want to open the form and display records, but if there is no record in the form i don't want to display form. what properties are available to recognise when a form's recordset is null?
  4. lrmac93

    Access date range query

    That works if either the FROM date or TO date im checking fall between a FROM date or TO date already in the database but i dont think it pulls the records where the dates im checking start before the FROM date and end after the TO date, even though they still conflict. I should explain the...
  5. lrmac93

    Access date range query

    i need a query to check two dates on a form (a date range) against the date ranges already in a table for conflictions. Basically i need to return records where any of the dates in the date range on the form conflict beteen any of the dates in the database. eg. if the form date range was [DATE...

Part and Inventory Search

Back
Top