"Date picker in Query"

Question

I have a query in ACESS 10 that prompts for a date and I would like to present a calendar to pick a date rather than key in the actual date.

How can I do this and is there a sample available?

Thanks, George.

Answer 1

George

Unfortunately, the date picker only works on form controls that are bound to a date field. There are lots of custom forms made to mimic the date picker. A good site to check is http://www.accessmvp.com/JConrad/accessjunkie/calendars.html

Using one of those calendar forms, you would create a form with a text box on it. Then use a calendar form to get a selected date into that text box. Then change your query parameter to use that text box as the prompt.

The prompt would be:

[Forms]![YourFormName]![YourTextBoxName]

Answer 2

One possible solution would be to have a little one-record table with one date/time field. Include this table in your form's recordsource query with no join line, and display the date field on the form. It'll have the date picker and you can use it in your query.

Answer 3

Hi Bill,

Thanks for the instructions.  I believe the example refers to picking preset dates that are contained in another form?

I was looking to have an actual calendar-like control in my query so a calendar would pop up and  I could pick any date for my query criteria?

I looked at the site you suggested and they all seemed to focus on selecting dates that were setup as specific dates in the calendar forms. 

Please let me know if you ever come across a sample that displays a calendar for a criteria in a query?

Thanks,

George.