report query criteria and date

DevAccess

Registered User.
Local time
Today, 11:13
Joined
Jun 27, 2016
Messages
321
Hello

I have menu which opens report and before that it asks for the date for input as criteria set in report datasource query is enter date.

this gives plain text box to enter date, is that possible to have datepicker instead of that ?

do I need to create a modal form for this and then need to give criteria as form[fieldname].value ?

something like this ?

Thanks
DD
 
this gives plain text box to enter date, is that possible to have datepicker instead of that ?
set the control format property to short date
 
set the control format property to short date

this is in query criteria, how we can format there ? you mean to say create a contron on form and format it ?
 
set the control format property to short date

Rather I would have said it should be input box because it is coming from query criteria.. I need to have date picker instead. As that is handy to choose date , so I think in query criteria I can not put such thing, do I have to create form modal window with date picker field, please help here.. or provide any alternative solution.
 
you can only do it through forms and you cannot open a form from a query. Google 'access search forms' for a wide number of different ways to do this
 
I am putting in query criteria :

[Forms]![FrmDateInput].[txtdateDlvrmmreport]

instead of opening that form it inputs input box as attached image..
 

Attachments

  • error.png
    error.png
    3.3 KB · Views: 66
Just putting the parameter in your query will not cause the form to open. You have to open the query with your datepicker form already open.
 
Yes I am clicking on run query directly to make form open, am I doing something wrong ?
 
My question is that earlier in crietria was like below.

[Enter Date MM/DD/YYYY] : now customer now wants date picker instead of just input box, so i created form with date picker and put in the query criteria as below.

[Forms]![FrmDateInput].[txtdateDlvrmmreport]

this query is associated with report and takes date as filter.

please help me if I am going in wrong direction.
 
on your search form have a button which will open the report
 
on your search form have a button which will open the report

I did not get you what is meaning of search form here ? do you mean date input form ? if so in that case query will take input from date input form ?
 
do you mean date input form ?
yes

Why don't you look at some of the access templates to get a better understanding of how forms work
 

Users who are viewing this thread

Back
Top Bottom