Printing sheet of labels not working

[Bruce Lawrence]

Access 97, trying to print on Avery 5260 label sheet.

I used the label wizard and told it the query to use. The results give
me what I want on the label however when I hit print or print preview,
all I see is 1 label in the upper left corner. Why isn't the entire
sheet filled with the same information as what is in the first label?

I want every label to ahve the same information in it.

Thanks

[fredg]

On 2 Dec 2005 11:45:12 -0800, Bruce Lawrence wrote:

Access 97, trying to print on Avery 5260 label sheet.

I used the label wizard and told it the query to use. The results give
me what I want on the label however when I hit print or print preview,
all I see is 1 label in the upper left corner. Why isn't the entire
sheet filled with the same information as what is in the first label?

I want every label to ahve the same information in it.

Thanks

How would Access know you want a full sheet of the same label unless
you tell it?

Do an advanced search at
http://www.groups.google.com

Search for all the words
Repeat Labels
in the *access*
newsgroups.

You'll find lots of information.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Bruce Lawrence]

It wouldn't know unless I told it or knew how to tell it hence the
reason why I posted the issue on this group. Thanks for the link.

[Ted]

Another option would be to create a work table in your application
database. Run the append query X number of times, or write code to find
and append the record to your work table. Then base the label report on
the work table.
I don't know how efficient running a query X number of times would be,
but it would certainly assure you had just one name on your label for
the number of times you want it.
Let's say there are 30 labels per sheet.
I would run code similar to this to just run the query:
DoCmd.RunSQL "DELETE * FROM twrkRecordsForL abel" 'Clear the work table
of any old data
For X = 1 to 30
DoCmd.OpenQuery "qappRecordsFor Label" 'Appends the record based on
the criteria to the work table
Next X
DoCmd.OpenRepor t "rptLabels5 260" 'Print the labels

Ted

[pietlinden]

nah, there's code in Access Developer's Handbook that will print a
varying number of labels for each record. I think you need to get the
book to get it, but I've never heard of anyone saying he didn't get his
money's worth...

[Randy Harris]

<pi********@hot mail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

nah, there's code in Access Developer's Handbook that will print a
varying number of labels for each record. I think you need to get the
book to get it, but I've never heard of anyone saying he didn't get his
money's worth...

I just looked at Amazon. There are a bunch of used copies of The Access 97
Developers Handbook starting at $5.25. Most, but not all!, included the CD.
It's a superb book.

[Wayne Gillespie]

On 2 Dec 2005 11:45:12 -0800, "Bruce Lawrence" <BL*****@gmail. com> wrote:

Access 97, trying to print on Avery 5260 label sheet.

I used the label wizard and told it the query to use. The results give
me what I want on the label however when I hit print or print preview,
all I see is 1 label in the upper left corner. Why isn't the entire
sheet filled with the same information as what is in the first label?

I want every label to ahve the same information in it.

Thanks

You can used a query with a cartesian join.
Create a table (tblLabelNos) with one field (LabelNo) and add one record for each lable you want to print.
1,2,3,4.....30
Add this table to the recordsource of the report with no joins to any other table.
When the report is run, the recordsource will return one record for every record in tblLabelNo's. You can adjust how
many copies of each lable are printed by controling the number of records in tblLabelNos.

[Bruce Lawrence]

Thank you Wayne! I knew exactly what you were talking about and didn't
even think of doing it.

It works beautifully. I simply dont show the labelno field on the
report. What I'm going to do is create a module to ask the user how
many labels they need and pre-calculate the number of sheets to print.

Thanks again !