This database will be used in MS Access 2000. One task for the database is to fill in the form QM_Nonconforming_f then print 1 to 50 labels from the report QM_Nonconforming_r depending on the number entered in the TotalLoadsTagged field. I have tried to follow instructions for macros and modules and I cannot get it to work properly. I got it so mixed up that I started over with a fresh copy of the db.
I have a simpified test copy at www.cjkurtz.com/test/qmis.htm
Here is what I want to do.
1. Fill in the form QM_Nonconforming_f
2. Click a button that will
a. save the record
b. print the record as QM_Nonconforming_r (without previewing the report)
c. and when printing the form it should count and print the copy number on the record
for example: it prints Load (NUMBER) of 10 Loads. 10 is read from the form field:
and 10 reports are printed with 1of 10, 2 of 10, etc. printed on the reports.
d. I will also send one copy of an email, but I have figured that out
e. display a new blank form
In my various attempts using macros with openreport and printout, I can't seem to select the correct record, or output the correct number of copies reading the quantity from TotalTaggedLoads field from the form.
At one point in a module I was able to printout the correct number of copies but it also printed out the form.
I have not been able to come close to having the correct number of copies print out. I tried using the page function, but that just gave me 1of 10 on all the copies.
This shouldn't be that hard but I have spent hours on this and I am finally asking for help. Thanks.