How Do I Get A Calendar Into A Query Parameter
SELECT Scrap_Q4.REJ, Scrap_Q4.When, Count(Scrap_Q4.REJ) AS CountOfREJ
GROUP BY Scrap_Q4.REJ, Scrap_Q4.When
HAVING (((Scrap_Q4.REJ) Between 108 And 132) AND ((Scrap_Q4.When) Between [start date] And [end date]))
ORDER BY Scrap_Q4.REJ, Count(Scrap_Q4.REJ);
I want to replace the parameter box from popping up with a calendar which will alow the user to click on a start date and an end date. This will eliminate typing and potential error
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have added in the query names I will be using and the main form to be opened.
I tried using DoCmd.RunSQL, but, if I understand correctly, this can't be used for a select statement. I used it with updating and inserting with no problems.
I'm trying to use qdf.Parameters() now, but I still get the popup. Is there a way to pass parameter without the parameter prompts?
In more detail:
I created a query where I have a pop up parameter box that asks for the start date and another asking for the end date. The parameter is written in the criteria as follows:
Between [start date mm/dd/y] and [end date mm/dd/y]
When I run the query, the parameter query works beautifully.
So then, I ran a crosstab query based on the (first) parameter query hoping that it would pull the parameter query forward, but it didn't, I got the error message instead.
what I am trying to achive is.
when a date is selected from the calendar it will show the query results in a datasheet or some other type in the same form?
can anyone advise what is the best way to approach this?
Due to a new feature, I would like to refresh that query without having to reenter the query parmeter.
Can I refresh a parameter query using a previously entered value as the parameter value?
This query is the record source for a form so I was not wanting to change this, but pass a value into the parameter required to run the query
How I get information from a calendar to a query behind a form that will display closed problems for a chosen month. The calendar form currently has date and year and no multiple date sections without using a global. Do I need a dialog form?
I would like to add one thing to the "design" of the query; I would like to have a DatePicker pop up to enter the parameter instead of the default parameter-entry dialog box. Everything I have read on the web says I cannot do this directly through the query.
Instead, it seems I must first create an unbound form (frmStart_Schedule) using a TextBox (cboDatePick) with format set for Date/Time to provide the parameter for the query.
What I am having trouble with is having the SQL code "point" toward the value entered in cboDatePick in order to run the query (which contains the user-defined function DoReview,