best way to do a parameter query for selecting a month

  • Thread starter Thread starter Neal
  • Start date Start date
N

Neal

what's the best parameter to use on a date/time field to select a date?

We want a query to show results from 16 Jan or 15 December or 12/6.

Can one parameter cope with the different possible inputs from users?

Thanks, Neal.
 
Neal,

In my experience, the safest way to get user input for dates is to use a
calendar control on a form, and have your query criterion read the
selected date; otherwise, it is highly likely that users will type in a
date in the wrong format... moreover, if you are in a country where the
standard date format is non-US, there is an additional high risk of
different computers behaving differently on account of different date
formatting in the regional settings.

HTH,
Nikos
 
I usually provide a combo box whose RowSourceType is a Table and whose
RowSource is a list of all available dates only, and that skips non-valid
dates, and that's sorted conveniently. That way (if you do the work up front),
the user can't possibly enter an invalid date.

Sam
 
That will do me thanks! (-:

Neal

OfficeDev18 via AccessMonster.com said:
I usually provide a combo box whose RowSourceType is a Table and whose
RowSource is a list of all available dates only, and that skips non-valid
dates, and that's sorted conveniently. That way (if you do the work up
front),
the user can't possibly enter an invalid date.

Sam
Click to expand...
 
Back
Top