Results 1 to 6 of 6
  1. #1
    rmoore is offline Advanced Beginner
    Windows XP Access 2016
    Join Date
    Feb 2020
    Posts
    47

    Date Picker


    I have a query with a criteria of Between [start date] and [end date].

    When the query is run the "Enter Parameter Value" box appears, Is there a way to have the date picker instead of manually entering the date?

  2. #2
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    You can't with the Enter Parameter Value box. You'll need to make your own form with a date picker and either have the query reference that form OR send the date to the query as a parameter pragmatically.

    How is the query being called by the user?

  3. #3
    rmoore is offline Advanced Beginner
    Windows XP Access 2016
    Join Date
    Feb 2020
    Posts
    47
    It's being called by a report.

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    and what calls the report?

  5. #5
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    report might be call from some form, Place date from and date to field in form so that it will have date picker and then call report .

  6. #6
    Bullschmidt's Avatar
    Bullschmidt is offline Freelance DB Developer
    Windows 10 Office 365
    Join Date
    Mar 2020
    Location
    USA
    Posts
    64
    And you might hopefully find this article helpful:

    Create an Interactive Access Form to Filter a Query by Date Range
    Posted by Dan St. Hilaire / April 23, 2012 / Access — 46 Comments ?
    https://www.knowledgewave.com/blog/m...e-range-2.html
    And can change the last part so that instead of opening the query it opens a report whose RecordSource is the query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date picker
    By Jen0dorf in forum Access
    Replies: 1
    Last Post: 03-11-2016, 10:54 AM
  2. Replies: 11
    Last Post: 06-28-2015, 06:42 PM
  3. Show Date Picker on Load and Verifying Date
    By Markb384 in forum Forms
    Replies: 4
    Last Post: 03-04-2014, 07:44 AM
  4. Date criteria using between and form date picker
    By killermonkey in forum Queries
    Replies: 3
    Last Post: 03-21-2013, 12:44 PM
  5. Date Picker?
    By gazzieh in forum Forms
    Replies: 9
    Last Post: 02-09-2013, 09:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums