Label printing

[groupy]

Hi,

One of the users of my ms access database had the following request:

The user want to print 1 special label and 4 normal address labels in one action (special label report). At the moment the user must start the special label report, print 1 label. Close report, open standard address label report, print 4 labels.
The problems is that the user does this many many times on one day. So that is the reason that she ask for one report.

I allready implemented the labelsaver part. This means that I can choose on which label position I want to start and howmany of them.

Thanks a lot for your help or suggestions.

 

[ghudson]

Throw the label data into a temp table and call the label report for that table. Delete all of the records from that table when you call that action so that the user only prints the records they want.

HTH

 

[Pat Hartman]

Rather than creating a temp table, which can be problematic in a multi-user environment, just use a union query as the recordsource for the label report. That has the same effect (it produces a single recordset from multiple recordsets) as appending both recordsets to a table.

 

[groupy]

Thanks a lot for your input.

I will give it a try.