Using Access to Make Word Name Badges

[AngenitaC]

I hope I can explain this concept.

I am trying to use Word to make name badges for an upcoming conference. The
database is in Access. I want to print off a page that not only has the name
badge of the attendee, but also their individual tickets as well. I am having
a hard time because I can get it to print, I just can't get it to create a
new page for another attendee. They all run together, which is my first
issue. I think if I can get past the first issue, then my second issue will
be rectified.

Also, I used a template from the microsoft.com website, and modified it for
this conference last year.

 

[Arvin Meyer [MVP]]

Use an Access label report. Then you won't need Word. Avery has dozens of
Badge labels:

http://www.avery.com/avery/en_us/Se...D(SITESCHANNELS:Avery.com)&Ntt=Badge&x=10&y=4

most of which can be used with the Access Label Wizard

 

[AngenitaC]

The issue is not with the labels, it's what is printed on the sheet. When I
try to make a report from it, it just prints each indivual name badge. I also
want to print tickets to the events to keep everyone's name with their events
together instead of printing out x amount of tickets, then going back to make
sure that all participants have the tickets....does that make sense?

 

[Mr. B]

Have you tried creating your label and your tickets in the Detail section of
an Access Report. Then select the Details section, display the Properties
dialog box and set the "Force New Page" property to "After Section"?

That should give you one page for each record.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm