printing the same report multiple times from one line item

Does anyone know how to trigger a report to print as many times as a value in
a textbox.
I would need to use this in a ticketing system.

eg. a group buys 8 tickets, i create one line item and change the quantity
field to 8, i then need to click on a button to print 8 tickets.

please bear in mind that i am using Access2 and it does not have a lot of
features as the later versions.
Any help or advice would be appreciated.

You might want to try:
-create a table of numbers: tblNums
-add a single, numeric field: Num
-add records for values 1 through your maximum ticket quantity
-add tblNums to your report's record source
don't join it to other tables
-add the Num field to the query grid
-set the criteria under the [Num] column to
=[Forms]![frmYourForm]![txtNumOfTickets]

This will print a single report with mutliple copies of the same record.

--
Duane Hookom
MS Access MVP
--

"puso" wrote in message
news
Does anyone know how to trigger a report to print as many times as a value
in
a textbox.
I would need to use this in a ticketing system.

eg. a group buys 8 tickets, i create one line item and change the quantity
field to 8, i then need to click on a button to print 8 tickets.

please bear in mind that i am using Access2 and it does not have a lot of
features as the later versions.
Any help or advice would be appreciated.

i dont fuly understand your post , i have done what you have said refrencing
it to my forms and textbox but it still gives me an error an doesnt work.
is this the pnly way to fix my problem or is there another way?
ive been told to try coding in my reports on print command , do you know
anthing about this?
also bear in mind that i am using access2.0

"Duane Hookom" wrote:

You might want to try:
-create a table of numbers: tblNums
-add a single, numeric field: Num
-add records for values 1 through your maximum ticket quantity
-add tblNums to your report's record source
don't join it to other tables
-add the Num field to the query grid
-set the criteria under the [Num] column to
=[Forms]![frmYourForm]![txtNumOfTickets]

This will print a single report with mutliple copies of the same record.

--
Duane Hookom
MS Access MVP
--

"puso" wrote in message
news
Does anyone know how to trigger a report to print as many times as a value
in
a textbox.
I would need to use this in a ticketing system.

eg. a group buys 8 tickets, i create one line item and change the quantity
field to 8, i then need to click on a button to print 8 tickets.

please bear in mind that i am using Access2 and it does not have a lot of
features as the later versions.
Any help or advice would be appreciated.

Stating "gives me an error an doesnt work" suggests you aren't willing to
help us with your issue. We can't see your error message or your results.

Can you share the SQL view of your query?

--
Duane Hookom
MS Access MVP


"puso" wrote in message
...
i dont fuly understand your post , i have done what you have said
refrencing
it to my forms and textbox but it still gives me an error an doesnt work.
is this the pnly way to fix my problem or is there another way?
ive been told to try coding in my reports on print command , do you know
anthing about this?
also bear in mind that i am using access2.0

"Duane Hookom" wrote:

You might want to try:
-create a table of numbers: tblNums
-add a single, numeric field: Num
-add records for values 1 through your maximum ticket quantity
-add tblNums to your report's record source
don't join it to other tables
-add the Num field to the query grid
-set the criteria under the [Num] column to
=[Forms]![frmYourForm]![txtNumOfTickets]

This will print a single report with mutliple copies of the same record.

--
Duane Hookom
MS Access MVP
--

"puso" wrote in message
news
Does anyone know how to trigger a report to print as many times as a
value
in
a textbox.
I would need to use this in a ticketing system.

eg. a group buys 8 tickets, i create one line item and change the
quantity
field to 8, i then need to click on a button to print 8 tickets.

please bear in mind that i am using Access2 and it does not have a lot
of
features as the later versions.
Any help or advice would be appreciated.