printing the same report multiple times from one line item

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
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 said:
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.
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top