?
Solved

do until to print report for each record in a query

Posted on 2014-12-08
4
Medium Priority
?
293 Views
Last Modified: 2014-12-09
Experts. The collections department at my company is going to send out a year end settlement letter. I have a query of all of those individuals. In that query is their name and address. I need a one page report to print out for each individual in this query that includes their name and address for mailing.

I haven't been able to find any vba code that I could put behind a 'print' button. Anyone have an example or advice?

TIA!
0
Comment
Question by:acramer_dominium
[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 18

Accepted Solution

by:
Simon earned 2000 total points
ID: 40487730
I would suggest that you create a report based on your query. You can use the report Wizard to get you started. In the properties of the detail section, set the property "Force New Page" to "After Section".

You can do more or less the same without the grouping by just forcing new page AFTER each detail section.
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 40488607
You could also use Word to do a Mail Merge.
0
 
LVL 18

Expert Comment

by:Simon
ID: 40488666
Oops, when i look back to my previous post I can see I edited it badly. The last line ("You can do more or less...") should be ignored.

Rob's correct that you can do a mail merge in Word - the only thing you can't do with that is insert report details if there is a list of items that apply to each individual - if this is not the case, Word mail-merge is often the simplest route.
0
 

Author Closing Comment

by:acramer_dominium
ID: 40488879
Awesome! I never thought of doing a force new page. I had the query as the record source, just made this one little change to the detail section. Works perfectly!! I was making it too difficult. Thank you very much!!
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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

770 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