none
MS Access Query Automatically Change Criteria When Opened RRS feed

  • Question

  • I inherited an application that contains a query I inadvertently changed.  I have no way to get it back; therefore, I have to come up with a fix.  I have been unsuccessful thus far.  The query contains a criterion for a date field as follows:

    > #1/1/2019# And <= #12/8/2019#

    The query automatically substitutes the first date with the first day of the current year.

    The query automatically substitutes the second date (i.e. 12/8/2019) with today's date automatically.

    The query did not use the Now() or Date() function.

    It seemed to execute some code given the "On Open" or "On Load" event; however, I don't know how to get to the source code for this event in a query object.

    There is no Form or Report involved.

    Thank you for reading this question.

    Monday, December 9, 2019 4:55 PM