M
mackie
sharing some info on how to control the paper source when
printing a report.
there are articles i read from o'reilley's access cookbook
on how it can be done.
what i did was not the best way and somebody here can help
me get the finishing touch to make it smoother.
the report's datasource are grouped by id
so what i did is create a table from that recordsource
with unique id. using that table i created a loop till
then end.
i then printed the report with record source filtered
using id
(what happened is something like i printed the report
individually but not manually)
first, i configured the report's page setup using a
specific printer. then selected the paper source for page 1
(bin1) and all other bins for succeeding pages)
then using the printer's printing preferences, i
configured the bin 1 to use cover/letterhead and bin2 just
letter.
i can now print the report's first page using letterhead
and all other pages using bond...(btw, its full duplexed
printing)
printing a report.
there are articles i read from o'reilley's access cookbook
on how it can be done.
what i did was not the best way and somebody here can help
me get the finishing touch to make it smoother.
the report's datasource are grouped by id
so what i did is create a table from that recordsource
with unique id. using that table i created a loop till
then end.
i then printed the report with record source filtered
using id
(what happened is something like i printed the report
individually but not manually)
first, i configured the report's page setup using a
specific printer. then selected the paper source for page 1
(bin1) and all other bins for succeeding pages)
then using the printer's printing preferences, i
configured the bin 1 to use cover/letterhead and bin2 just
letter.
i can now print the report's first page using letterhead
and all other pages using bond...(btw, its full duplexed
printing)