Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    364

    Unanswered: Ideas for selecting dates on a form to be used with queries?

    Hello,

    I would like to begin to create a form which allows me to select dates e.g. (day/month/year).

    The idea is I would like to select a beginning date e.g. 01/01/2010 and an end date e.g. 31/01/2010 and display some reports based on queries between the dates.

    But first I would like to know what is the best way to display the two dates on a form? Would it be using comboboxes for the day, the month, and the year, or should I use the calendar control which comes with Access 2003?

    Any help would be much appreciated

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    depends on your business requirements
    could be a datepicker control, could be a combo of valid dates
    its entirely up to you.

    what I've used in the past is a switchboard/menu. you can set parameters by calling another form., that form then sets the readonly values on the menu/switchboard. the forms/reports pick up those values.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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