Label Problems

[jurgen]

Does somebody have experience with label printing with barcodes in access ?

I want to duplicate one label over a whole page with labels.
pe.

record to print x
labels on 1 label sheet 15
so record x 15 times on the label sheet

anybody some suggestions ? or has done this ?

JJ

 

[Aivars]

Hi!

Maybe you can rephrase your question?
Aivars

 

[JerryDennison]

You've got a couple of ways to approach this. One is to create the entire page of labels on your report placing 15 copies of each field in the appropriate label position. The other is to have a table with 1 field and 15 records. Add this table to your report's query and you'll get 15 copies of each record.

 

[jurgen]

Thnkx , i've used the method with the table, but on a network i still have some problems... if 2 users print at the same time

I think I've to adjust the table a little bit

Regards


Jurgen

 

[JerryDennison]

Make sure the network printing is being handled by a common queue.

 

[JoeMiller]

In the detail section of your report where you place the label control, in the print event put the following code:

If [MyCopies] = 0 Or IsNull([MyCopies]) Then
Me.NextRecord = True
Me.MoveLayout = False
Me.PrintSection = False
Else
If PrintCount < [MyCopies] Then
Me.NextRecord = False
End If
End If

You will need something to hold the [MyCopies] # be it a field or hard code it to 15 for example. I use a form where the user selects the # of labels they want and then presses the Print button where they get that many labels.

HTH
Joe Miller
joe.miller@flotech.net