Print report to Image Writer creating a field name to the file

[bmac]

Hello - My print preview document contains 10 survey questions done by 10
different respondents.
I want to print each respondent separately to the Microsoft Document Image
Writer using the respondent ID and Letter descrption.
eg. 123_Letter, 455_Letter, 456_Letter

thank you

 

[Larry Linson]

Hello - My print preview document contains 10 survey questions done by 10
different respondents.
I want to print each respondent separately to the Microsoft Document Image
Writer using the respondent ID and Letter descrption.
eg. 123_Letter, 455_Letter, 456_Letter

Perhaps you could clarify -- because I'd have to guess at what data you have
and what you really want to accomplish. You, after all, have your database
at hand, but all we have to go by is what you post here.

If I had to guess, I'd guess that your Report contains all the respondents,
but you want a separate Report for each of them. You might do that with
DoCmd.OpenReport, using a WhereCondition argument to specify the Respondent
ID . . . check Help on that. I'd also be guessing about whether you are
agreeable to doing this manually, or if you want to automate "printing to
Microsoft Document Image Writer". If the former, you can create a Form and
from a Combo Box, choose the Respondent ID, which you then insert into the
DoCmd.OpenReport.

I don't have any idea what you are talking about in re: "respondent ID and
Letter Description" unless you want to use that for the filename of the
report. I've never used "Microsoft Document Image Writer" as the "printer"
for Reports.

Larry Linson
Microsoft Office Access MVP

 

[bmac]

First, thank you for responding and secondly I apologize for any confusion.

My database captures survey responses and is tracked by a unique Respondent
ID.
I want to be able to use this ID as part of the output filename along with a
description.
I wouldn’t want to do it manually as there may be up to 100 surveys entered
by various individuals. Using Microsoft Document Image Writer was a
suggestion made to me, but doesn’t have to be the tool of choice.

 

[Larry Linson]

You can use VBA code to obtain the Respondent ID, and create and run a
report for each Respodent. There is information that you can search and
find on how to send reports by e-mail, too.

Larry Linson
Microsoft Office Access MVP