LABELS - Can Anyone Help

[TECHO]

I have items in a database and have a query linking these items to
description and batch numbers - Would like to be able to print labels based
on quantity..? but can only get 1 label of each item to print - Can Anyone
help...?

Techobeat

 

[John Vinson]

I have items in a database and have a query linking these items to
description and batch numbers - Would like to be able to print labels based
on quantity..? but can only get 1 label of each item to print - Can Anyone
help...?

There's a neat trick you can do with a (normally undesirable)
Cartesian Join query.

Create a table named Num, with one field N; manually (hint: use Excel)
fill N with values from 1 to the most labels you'll ever want. (Be
generous - I routinely have a Num table with values 1 to 10000).

Base the label Report on a Query retrieving your data, but add the Num
table to the query, with *no* join line.

As a criterion on N put

<= [Quantity]

using the name of the table field specifying the number of copies
desired for each label; it can be a different quantity for each label
if you wish.

 

[Newbie]

use DoCmd.PrintOut , , , , 2

The 2 = no. of copies but you could set this to a variable
for eg
copies = inputbox("How many copies","Labels")
docmd.PrintOut , , , , copies

each time the use will be prompted for a qty

HTH

Al