printing payment cards

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi

I hope somebody can help me!

I have a form with student details (enroled in an English language school)
and they can pay for it in upto 6 monthly payments.

I want to include the full amount to be paid and the number of payments to
be made.

Automatically, I want Access to divide the fullpayment field by the number
in the months field and print out the number of invoices necessary ( the
number in the months field) including the monthly payment.

Any ideas how I can go about this? I have the form made up and it works
great, I have the invoice designed, but I can't figure out how to control
the number of invoices to print.

Many thanks for any advice you can provide...

Jeff
 
You can either set the number of copies in Printer
options programatically, or just issue the print report
how ever many times you need. j.
 
Jennifer
Thanks for your quick reply.

I have been printing out the invoices using the printer settings, but it
takes a looong time when you have over 200 students.

I want to be able to click on one button and print the invoices for every
student in one go. It would save time.

Is it possible? It seems to me that this is a simple necessity for any small
business using Access.

Thanks for all the help

Jeff
 
Yes, you add code behind the button to loop thru the
students printing the report for each one. If you need
to print multiple copies, then you can add code to loop
how ever many times and print the same invoice for the
same student. Then move on to the next student and print
the invoice again.

Or you could modify the report to process all the
students and just print the invoice for each student on a
separate page. j.
 
Jeff said:
Hi

I hope somebody can help me!

I have a form with student details (enroled in an English language
school) and they can pay for it in upto 6 monthly payments.

I want to include the full amount to be paid and the number of
payments to be made.

Automatically, I want Access to divide the fullpayment field by the
number in the months field and print out the number of invoices
necessary ( the number in the months field) including the monthly
payment.

Any ideas how I can go about this? I have the form made up and it
works great, I have the invoice designed, but I can't figure out how
to control the number of invoices to print.

Many thanks for any advice you can provide...

Jeff
Click to expand...

I believe the following scheme will get you there. Suppose you have a
table StudentDetails with these fields in each record:

StudentDetails
---------------
StudentID (primary key)
FullPayment (currency)
PaymentMonths (number/byte (or /integer or /long)
... other fields, some related to the invoice

Now also have a table named, say, Coupons, with one field:

Coupons
---------
CouponNumber (primary key, number/byte (or /integer or /long)

Put exactly 6 records in table Coupons, numbered 1 through 6.

Now create a query, qryPaymentCoupons, with SQL like this:

SELECT
StudentID,
FullPayment,
CouponNumber,
FullPayment / PaymentMonths AS CouponAmount,
(other necessary fields)
FROM
StudentDetails, Coupons
WHERE
CouponNumber <= PaymentMonths;

That query should return as many records for each student as the number
of payment months in the StudentDetails record, and the calculated field
CouponAmount should be the result of dividing FullPayment by
PaymentMonths. Now base your report on qryPaymentCoupons, with the
report's detail section printing a single coupon.
 
Back
Top