auto input current date?

[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

 

[Van T. Dinh]

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)