By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,317 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

How would you...(report vs numbered copy)

P: n/a
I have a record with with a quantity value. I have to print one record for
each quantiy with a counter, incrmementing on each copy. I wan't to avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job number and
the cumulative quantity value. But I am not satisfied. Is there a way to
do this without a temporary table, from within the report's code only? TIA.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

Saintor wrote:
I have a record with with a quantity value. I have to print one record for each quantiy with a counter, incrmementing on each copy. I wan't to avoid to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job number and the cumulative quantity value. But I am not satisfied. Is there a way to do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.

Nov 13 '05 #2

P: n/a
But you won't get an incrementing number on each copy.


<pi********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Saintor wrote:
I have a record with with a quantity value. I have to print one

record for
each quantiy with a counter, incrmementing on each copy. I wan't to

avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job

number and
the cumulative quantity value. But I am not satisfied. Is there a

way to
do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.

Nov 13 '05 #3

P: n/a

Not sure if I understand correctly, but I would probably try to make a loop,
calling the report with an openargument passing the number (newer access
versions only).

Alternatively make an unbound textbox on your form, and change the value
every time before you print the report. In the report reference this control
with something like
=Forms("FormX")![FieldY]
Alternatively, make a public variable in a module (not a form module) and
fill that from your form, and read that from your report (inserting it in
the appropriate place).

Good luck,

Bas.

"Saintor" <sa******@REMOVETHIShotmail.com> wrote in message
news:C_********************@wagner.videotron.net.. .
But you won't get an incrementing number on each copy.


<pi********@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Saintor wrote:
I have a record with with a quantity value. I have to print one

record for
each quantiy with a counter, incrmementing on each copy. I wan't to

avoid
to use many docmd.openreport instructions.

I succeeded by creating a temporary table, adding by code the job

number and
the cumulative quantity value. But I am not satisfied. Is there a

way to
do this without a temporary table, from within the report's code

only? TIA.

One of the arguments of PrintOut is the number of copies you want to
print... just pass that in your print command.


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.