Solved

Access 2003 Fitting data to a Avery business card.

Posted on 2009-07-08
4
253 Views
Last Modified: 2012-05-07
I have an app that prints out an id card front and back . we cut it and fold then laminate and its good to go. My problems are that i get 1 per page and they would fit on an avery business card.  I have the sizing right (almost) but am not able to get mult on 1 page. In design view the Report header is closed , Page header is closed, detail has my fields and graphics, Page footer and report footer are closed and empty. I would almost bet that there is a proprty I am ignorant about that would make this all work...Please enlighten me..
0
Comment
Question by:SteveMcCoyOregon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 24809553
Access has a "Label Wizard" you can use to build a report, then format that to match the size of your Avery label. Select the Reports tab in the database window, click "Create Report by using Wizard", then select "New" (don't just doubleclick the "Create Report" line, make sure to click the New button). You can then select the Label Wizard selection, choose your table/query, then build the report. Access has a lot of different formats which match the Avery sizes, and even uses the Avery number designation.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 24810448
<No points wanted>

LSM has your answer.

FWI, Basically the Wizard uses the "Colums" option from the Page setup Dialog box to fill the "Page" with cards.

JeffCoachman
0
 

Author Comment

by:SteveMcCoyOregon
ID: 24810720
looks like the formats is good -not sue about left right/ front back paging though.
0
 

Author Closing Comment

by:SteveMcCoyOregon
ID: 31601360
I was able to easily solve my issue thanks to the pointers provided. I made a custom label representing a large 1 up label so my front back issues were satisfied. THANKS For the quick reply.

Steve
0

Featured Post

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question