Printing Labels

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

Guest

I have a report to print labels based off of a query, which could have one
record or 500 records. The problem is that I would like each record to print
out a diffrent quantity. For Example, Lets say record 1 has equals one box
and record 2 equals 5 boxes and record 3 equals 4 boxes. I want record 1 to
print 1 label and record 2 to pring 5 lables and record 3 to print 4 labels.
Since it is one report with multiple records and each record would be one
page, can I have diffrent pages automatically print diffrent quantities.
 
Thank you very, Your suggestion was very useful.

David C. Holley said:
So you have a field say noBoxes which varies from record to record? I'm
thinking that you'll probably need to use a temp table and DAO code to
populate it based on the value of the field. The DAO code would loop
through the records that required labels and then based insert into the
temp table the number of records required by the noBoxes field (or
whatever the field name is). Then its just a matter of printing the
labels. Once advantage to this is that you could do a label# of XLabels
so the person knows the number of labels/boxes to expect.
Click to expand...
 
Thank you your suggestion was very usefull. The specific how to instructions
were great.
 
I do have one question for you. The code that you gave me was using DAO Is
there an ADO version.

Thank you
 
The code was only for loading the tblCount with data.
It's very easy to use an ADO recordset if you prefer.

Or you could just open the code window, choose References from the Tools
menu, and temporarily check the box beside:
Microsoft DAO 3.6
 
Im fine with the DAO, I just thought that ADO is newer and should try to stay
with the newer technology when possible. Once again I really appreciate your
help, especially since I dont do much with VBA. I would like to do more with
VBA, it seems to be extremely powerfull and it would help with ASP, seeing
that my company would like me to learn ASP.
 
Back
Top