range printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!

I have a db with 4000+ records. When I print reports, I want to have the
ability to print all the records or only one particular group without first
having to scroll through print preview to find out the page range.

Any help is appreciated.
 
-----Original Message-----
Help!

I have a db with 4000+ records. When I print reports, I want to have the
ability to print all the records or only one particular group without first
having to scroll through print preview to find out the page range.

Any help is appreciated.
.
Click to expand...
 
you need to have a query to select the records you want
printed. you may need multiple gueries for multiple
selects.
 
Access Queen said:
I have a db with 4000+ records. When I print reports, I want to have the
ability to print all the records or only one particular group without first
having to scroll through print preview to find out the page range.
Click to expand...


The standard way to do this is to create a simple unbound
form with a text box where you can specify the "group" you
want to see in the report. The form would also have a
button to print/preview the report.

The code behind the buton would then use the value in the
text box to specify filtering expression as it opens the
report. The button wizard can generate most of the code for
you and you can search help and newsgroup messages for
OpenReport and WhereCondition to find examples.
 
Base your report on a query and use parameters in the query to select what
to print. Criteria in the appropriate field would look like:
Between [Enter Where To Start Here] And [Enter Where To Stop Here]

Look at parameter queries in the Help file.
 
Back
Top