Muliple labels from one record

[Guest]

Help - I have a query with one record and want to make sheets of labels for
that one record. How do I do it in Access.

 

[Guest]

from Hong Kong, RainbowSix

First:
Make a table to store the data for printing

Second:
Make a form for user interface to choose how many labels want to print
after choose no. of label and click a button, you can use DAO's recordset
object to AddNew
Dim rst As DAO.Recordset
Set rst = CurrentDB.OpenRecordset("YourTempTableInFirstPoint")
For i = 1 to YourNoOfLabelPrint
rst.AddNew
.....
.....
rst.Update
Next
then open your report with using this table

you can using SQL statement to delete all records in this table in form's
OnClose event



"Sharv" 來函：

 

[Al Campagna]

Sharv,
Let's say your table (ex. tblAddresses) only had one record, and you want 10 labels of
that record.

Create a new table called tblCounters, with one numeric field (ex. NoOfLabels
(integer)).
Populate that table with 1, 2, 3, 4, etc... for the maximum number of duplicate labels
you would ever want.

On the form that calls the labels (ex. frmYourCallingFormName), place an unbound field
called PrintCount.

In the query behind the report, bring in tblCounter, and drag NoOfLabels to the grid.
Place this criteria against that field...
<= Forms!frmYourCallingFormName!PrintCount
DO NOT make any connection between tblAddresses and tblCounters.
This will create a Cartesian relationship that will force the query to create multiple
address records for each item in tblCounters.

Now, while on the form, and viewing the record you want to print, enter 10 in
PrintCount, and call the report. The report will display/print 10 labels of the one
record.

 

[Larry Daugherty]

Go to Database|Reports. Make sure that wizards are enabled. click
New. Choose Label. Find your query. Step on through the wizard
telling it you want sheets of one label. That's it but for a few
details. There are many ways you can make it more useful and elegant.

HTH

 

[Guest]

I like your idea best as it is the easiest but I cannot find anywhere in the
label wizard that asks me about printing sheets of one label - what am I
missing?
Thanks

 

[Al Campagna]

Sharv,
I've never heard of that option in the label wizard...
The cartesian method I referred to... to allow any number of duplicate labels... is a
very popular solution.
If you search Google Groups under "public.access" "multiple" "labels" "duplicates"
you'll find many similar responses.

 

[Larry Daugherty]

I apologize to one and all, no such capability exists in the Access
wizard; which is probably why I was using Word. };-) I must have
MRPEd (an old mainframe term meaning Memory Register Parity Error).
Nothing to do but reboot the machine and roll back all processes to
their last checkpoint & restart.