auto input current date?

  • Thread starter Thread starter johnalcrazy
  • Start date Start date
J

johnalcrazy

Is there a code to queary a database by current date, ie:
to show all videos due for return "today", but automatic
so that the queary will tell you on opening those items
to for return "today" for example?

Thanks

johnalcrazy
 
Put the criteria

Date()

in the "DueDate" Column of your Query Grid.

You can use the OpenQuery action in the AutoExec macro to
run the Query on opening of the database.

HTH
Van T. Dinh
MVP(Access)
 
Back
Top