Printing

[Woody]

Is it possible to print only one page in a report without
selecting the page number in print mgr. For instance my
database report has one page for every record. I want to
print only the page that is shown on the screen. Also is
there a "greater than or equal to and less than or equal
to" in access. If so could someone offer advice on how
to use it.

 

[K. Allen]

I don't have an answer for the printing question.

For greater than or equal to, etc., do you mean in a
query? That is simply >= followed by the criteria. For
example, in a date field, >=7/1/2002 selects all the
dates that are from 7/1/2002 on.

 

[Van T. Dinh]

There is a "WhereCondition" argument in the OpenReport Method which you can
use to filter the RecordSource of the to the single Record that is shown on
your Form.

Check Access VB Help on the OpenReport Method for info. on how to use the
"WhereCondition" argument.