Full page of mailing labels for same name 1

[THWatson]

Using Access 2000

I want the user to be able to select a name from a list box and then print a full sheet of Avery 8160 mailing labels for that name.

I have searched old posts but can't seem to find what I am looking for.

Any suggestions would be appreciated.

Thanks.

Tom

 

[dhookom]

I generally include a table of numbers in my applications:
[tt][blue]
[tblNums]
=========
[Num] (numeric field with values 1 - maximum)
[/blue][/tt]
You can then add this table to the record source query of your report and add the Num field to the grid. Set the criteria under the Num field to:
Between 1 and 30
This should get you 30 copies of each record. You can set the criteria to filter the results to the value selected in your list box.

Duane MS Access MVP

 

[THWatson]

Duane
That is so neat. I see how it works. When that is added to the query grid, and is not bound to any field in the table from which the name is chosen, 30 instances of that name are generated.

Thanks very much.

I trust your grandson Jackson is, at his age, continuing to soak up his surrounding universe at an astounding pace.

Tom

 

[dhookom]

Thanks Tom. The query is a "cartesian product".

Jackson (now 4 1/2) is a sponge. This past Saturday he got some hands-on with hot air balloons Hot Air Affair in Hudson, WI.

Duane MS Access MVP

 

[THWatson]

Duane
Great pictures!

My youngest grandchild is Kennedy and she just turned 3 in November. If you are interested, a picture of her and me, from January 8, is at

http://picasaweb.google.com/TomWatso/Kennedy/photo#5164205781292178562

I just looked to see whether or not I had ever driven through Hudson, WI but it appears not.

Tom

 

[dhookom]

<obligatory Technical Reply>
Much of the functionality and flexibility of reports relies on the query/record source. You will struggle with creating reports if you don't understand queries.
</obligatory Technical Reply>

<Grandchild Reply>
Looks like Kennedy has red hair like Jackson. We also spend lots of hours in front of Papa's laptop traveling around the world and learning about far off places.
</Grandchild Reply>



Duane MS Access MVP

 

[THWatson]

Duane
Yep, Kennedy has red hair. There's some sprinkled throughout the family. My hair was never red, and now what's left is still not red but could be called sprinkled.

I realize what you say what understanding queries. This is the first instance I have had of a "cartesian product" being useful. In most things I have done, I have been trying to prevent that. However, obviously, everything has its use somewhere along the line.

Thanks again.

Tom