search records to print report

[Rkapoor via AccessMonster.com]

I am trying to create differnt reports from my form to display only certian
records and then print them for example

if the value of field is yes. only then that record should be visible to edit
or to print report for

also how can i add date range into that

please help

 

[Allen Browne]

You have a form where the user can enter their criteria, and then click a
button to open the report. You will need code in the Click event procedure
of the button to build the WhereCondition for OpenReport.

There's an example of how to build such a string (including the date range)
here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Although the example database shows how to filter a form, the procedure is
exactly the same for a report. Only difference is that when you have built
the filter string, you apply it to the WhereCondition of OpenReport instead
of the form.

 

[Rkapoor via AccessMonster.com]

Thanks for the reply

ehat i trying to do is. creat report for the user to take out reports based
on date range and if i have select yes for needing there help they can print
or preview a report where i have answered yes in the feild

for example

If i need resources to come to a site to do install, the end user can go in
at put the date range ( 10.1.2007 to 10.30.2007) and if resource field says
yes show me all records with yes in that field

please if this makes more sence to you all

thank

ritesh

You have a form where the user can enter their criteria, and then click a
button to open the report. You will need code in the Click event procedure
of the button to build the WhereCondition for OpenReport.

There's an example of how to build such a string (including the date range)
here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Although the example database shows how to filter a form, the procedure is
exactly the same for a report. Only difference is that when you have built
the filter string, you apply it to the WhereCondition of OpenReport instead
of the form.

I am trying to create differnt reports from my form to display only certian
records and then print them for example

[quoted text clipped - 6 lines]

please help

 

[Allen Browne]

The previous example shows you how to do that, and other things at well.

If it is too complex for you, this might be easier:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thanks for the reply

ehat i trying to do is. creat report for the user to take out reports
based
on date range and if i have select yes for needing there help they can
print
or preview a report where i have answered yes in the feild

for example

If i need resources to come to a site to do install, the end user can go
in
at put the date range ( 10.1.2007 to 10.30.2007) and if resource field
says
yes show me all records with yes in that field

please if this makes more sence to you all

thank

ritesh

You have a form where the user can enter their criteria, and then click a
button to open the report. You will need code in the Click event procedure
of the button to build the WhereCondition for OpenReport.

There's an example of how to build such a string (including the date
range)
here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
Although the example database shows how to filter a form, the procedure is
exactly the same for a report. Only difference is that when you have built
the filter string, you apply it to the WhereCondition of OpenReport
instead
of the form.

I am trying to create differnt reports from my form to display only
certian
records and then print them for example

[quoted text clipped - 6 lines]

please help