Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    9

    Unanswered: Criteria Removal on the Fly

    Between DateAdd("m",-1,Date()) And DateAdd("d",10,Date())

    I would like a button on a form to remove this from the query that the form is based on should the user want to all records.

    The for is from tracking the type of work completed during the day. There are 3 years worth of records. The part above makes everything about entering data faster. There are times however that a user will need to look back and modify older records.

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Look at "DemoCriteriaOnFlyA20022003.mdb (attachment, zip).
    Look at Table, Queries, Form (VBA).
    Open Form and try.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •