Serial Number while printing.

[mroks]

Guys, could you please help me on my problem? i just want to use the serial
number on my report but the problem is, i did'nt know how to use it properly.
here is my problem goes: i have 1 page of report, and i want to print it for
100 copies (meaning the 100copies had only one content). i want to have a
serial number for 100 copies. for example the first printout will have serial
number 1, the second is 2, the 3rd print out is 3 and for last printout will
have of course serial number 100. hope to hear from you guys.

thanks.

 

[Allen Browne]

So the first record in the report is printed 100 times, with the number 1 to
100 on each. Then the next record is printed with its counter starting from
1 again?

If that's the idea, you could use the approach explained in this article:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

It explains how to generate the number of copies desired for each record,
and step 6 explains how to print "1 of 100" on the report.

 

[mroks]

Allen,

i got your points, thanks. but i have also another problem the constant value
declared on the code is not static, it should be base on the user input. how
can i do that.

regarding on the question below. theres no next record. my program created
and design to store 1 record only.

thanks

So the first record in the report is printed 100 times, with the number 1 to
100 on each. Then the next record is printed with its counter starting from
1 again?

If that's the idea, you could use the approach explained in this article:
Print a Quantity of a Label
at:
http://allenbrowne.com/ser-39.html

It explains how to generate the number of copies desired for each record,
and step 6 explains how to print "1 of 100" on the report.

Guys, could you please help me on my problem? i just want to use the
serial

[quoted text clipped - 10 lines]

thanks.

 

[Allen Browne]

At step 4, the linked article refers to a field named Quantity in your query
like this:
<= [Quantity]

Replace that with:
<= [Forms].[Form1].[Text0]
where Form1 represents the name of your form, and Text0 is the name of your
text box.

 

[mroks via AccessMonster.com]

Hi Allen,

Thanks.

I have other fields which contains data, on page 1 there was a data but on
the 2nd, 3rd and so forth there was none. how can i handle that?

thanks,

At step 4, the linked article refers to a field named Quantity in your query
like this:
<= [Quantity]

Replace that with:
<= [Forms].[Form1].[Text0]
where Form1 represents the name of your form, and Text0 is the name of your
text box.

Allen,

[quoted text clipped - 25 lines]

 

[Allen Browne]

Not sure I understand.

Perhaps the form needs to stay open behind the report, so that it works on
later pages.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have other fields which contains data, on page 1 there was a data but on
the 2nd, 3rd and so forth there was none. how can i handle that?

At step 4, the linked article refers to a field named Quantity in your
query
like this:
<= [Quantity]

Replace that with:
<= [Forms].[Form1].[Text0]
where Form1 represents the name of your form, and Text0 is the name of
your text box.

Allen,

[quoted text clipped - 25 lines]

Guys, could you please help me on my problem? i just want to use
the serial