Print Just One Record

[Ange Kappas]

Hi,
I have a report which is based on a query, which filters out
only one record.
I want to print only that one record at a time, without the printer going to
the next page.

How do I do that

Thanks
Ange

 

[Duane Hookom]

If your query returns only one record, then the report based on the query
should only return one record.

 

[Evi]

Hi,
I have a report which is based on a query, which filters out
only one record.
I want to print only that one record at a time, without the printer going to
the next page.

How do I do that

Thanks
Ange

Hi Ange

Do you mean that you have a report footer which prints on the second page?
If you mean that you get a second blank page then it means that something on
your report is too wide for your page. In Design view drag the report edge
as far to the left as it will go, so that it is as narrow as possible. Add
the width of both left and right page margins to this width and see if is
wider than a page width.

Evi

 

[Ange Kappas]

Hi Evi,
The problem is I will be using a Dot Matrix printer and all
I want is to print ONE LINE at a time every time I print the query which in
essence is only one line, without the paper going to the next page.

Thanks
Ange

 

[Rob Parker]

Aah, the problem changes ...

Have you tried redefining the page size for this printer to a custom size,
with the page height equal to the height of a single line on the DMP?

HTH,

Rob

 

[Ange Kappas]

Hi Rob,
The problem here is that the printers used do not have a
Custom Size option, all options are predefined(e.g Letter, A4, B5 etc).

Regards
Anger

 

[Rob Parker]

Hi Anger,

You're probably quite right. A while after posting my reply, I got to
thinking about ancient technology, such as dot matrix printers ;-)

IIRC, they had(/have) a front-panel button labelled "Form Feed" - or
similar. And they would respond to a form-feed character, sent in code, to
churn out the current page to the top of the next page - usually to the top
of the next tear-off perforation, unless someone had manually wound the
paper on ;-) So, if Access sends a FormFeed character at the end of each
page (and modern printers might well be able to define what a new page
length is, but a DMP almost certainly can't ), then your DMP will always
scroll to the next physical page, regardles of how you might try to define
the page size.

That previous paragraph seems a bit rambly, but it's late at night; hope you
understand what I'm getting at ;-)

And if you do, then I suspect that there's not a simple way of doing what
you want. A possible work-around might be to dump the data which you want
printed ito a temporary table, and then write some code to print a report
based on that table when it contains sufficient records to fill an entire
page. Not exactly trivial, but probably do-able if you're sufficiently
bloody-minded, and care enough about paper-wasting to make the effort ;-)

Best wishes for finding a solution,

Rob