Printing Business Cards using an Access Report

[Doug]

I have a database that allows selection of Members entered into an Event
along with their event information. I am trying to design a report that
would print a full sheet of business cards with 10 different Members names
and their information by selecting them into a report that would look like
the business card template in MS Word.

 

[Larry Linson]

In Access 2003 and earlier, the Report Label Wizard includes a template for
10 per page 2" x 3.5" Avery # 5371. I used this to create a report to print
membership cards for my computer user group... create the report which will
not be formatted as you desire, then open the report in design view and add
/ change controls and add images. On the database window, reports tab, click
the second option "Create report by using wizard".

I do not have a copy of Access 2007 installed on this machine, but I would
be very surprised if it does not have similar capability. As there is no
database window in Access 2007, you'd get to the wizard in a different way.
Perhaps an Access 2007 user will jump in and explain how to do so.

Larry Linson
Microsoft Office Access MVP

 

[Doug]

Thanks Larry
That was a good start. The part I don't know is how to select the 10 names
I want on a sheet from a Form or Table? As members enter a show the names
are added to a Form (Signup Table). Then how do I select the last 10 member
who entered to print in the Label Report?
Your reply helped me get the report in the proper format.
Thanks Doug
--
Doug
Small Business Databases

In Access 2003 and earlier, the Report Label Wizard includes a template for
10 per page 2" x 3.5" Avery # 5371. I used this to create a report to print
membership cards for my computer user group... create the report which will
not be formatted as you desire, then open the report in design view and add
/ change controls and add images. On the database window, reports tab, click
the second option "Create report by using wizard".

I do not have a copy of Access 2007 installed on this machine, but I would
be very surprised if it does not have similar capability. As there is no
database window in Access 2007, you'd get to the wizard in a different way.
Perhaps an Access 2007 user will jump in and explain how to do so.

Larry Linson
Microsoft Office Access MVP

 

[Larry Linson]

Order the sign-in list DESCending by date and time, then check help on the
TOP values operator, in a query, to get the most recent. There is a top
values property in the property sheet of Queries in the Query builder... so
don't worry that you'll need to become an SQL expert just to do this.

I'd guess, however, that "the ten most recent" may not be what you want
every time -- the very most recent, if you could print just one, or, however
many have signed in since you last printed. What you really need to do will
likely be dictated by the sign-in procedures you use at your gathering.

Larry Linson
Microsoft Office Access MVP

Thanks Larry
That was a good start. The part I don't know is how to select the 10
names
I want on a sheet from a Form or Table? As members enter a show the names
are added to a Form (Signup Table). Then how do I select the last 10
member
who entered to print in the Label Report?
Your reply helped me get the report in the proper format.
Thanks Doug

 

[Doug]

Larry;
Works great! I'll have to fine tune but I apprciate your responses.
Looks like it does exactly what I need.
Doug

 

[Larry Linson]

Thanks for your kind words. I'm glad I was able to be of some help.

Larry Linson
Microsoft Office Access MVP