Solved

do until to print report for each record in a query

Posted on 2014-12-08
4
276 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
  • 2
4 Comments
 
LVL 18

Accepted Solution

by:
SimonAdept earned 500 total points
Comment Utility
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 31

Expert Comment

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

Expert Comment

by:SimonAdept
Comment Utility
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
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
My experience with Windows 10 over a one year period and suggestions for smooth operation
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…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now