Date Picker for running a Query

[smckenna]

All,



I am using Access 2007. I have created a form where employees fill out the tasks they have completed and how much time has been allocated to that task. I have created a button on the form that runs a query so that they can see how much time they allocated for that day. At this point, they need to manually type in the date "2/26/2015" in order to run the query. I would instead like to have a date picker pop up so they do not need to manually input the date to run the query. How do I go about this?

Again, I have a form that the users fill out, they then run a query for a specific date to see total time allocated. I dont want them to type in the date manually to run the query, I would like a date picker to be used. Can anybody help?

Bests,
Sean

[June7]

Cannot invoke date picker in query. This is a feature of textbox on form. Query should reference textbox as parameter.

[smckenna]

How do I reference the textbox in the form?

[June7]

[Forms]!formname!textboxname

[smckenna]

Thanks. So i will never be able to utilize the date picker for selecting a date to reference info from my form? i will always have to manually enter a date?

[June7]

?? The date picker is available to textbox on form.

[reentry]

June7 has completely right, i think u misunderstand him.
He trys to say that u have to referer a textbox (which has a datepicker) to your query.

U have a Form with the textbox (name = txtDate).

Now u can make a query and instead of writing the date u refer to the text box example

Dim Sql as string
sql = "Select * From tblxyz WHERE columnDate =  " & Me.txtDate

As u can see after columeDate i refer to an open form with the Textbox named txtDate which has a datepicker.

[smckenna]

Sorry if i am confusing you.. maybe calling the calendar "date picker" is a problem.. i just assumed it was one and the same. Essentially, when i run my query, I want the start date parameter to have a calender button that the individual can select from instead of typing the date in manually. Is this possible? I want them to be able to run a query that shows how many hours they have completed for the day, but they would prefer to not have to type in a date.

[June7]

Comments still apply.

Queries cannot have buttons and textboxes and therefore no calendar.

Use a form.