Pass parameter to A2000ReportToPDF

P

Peter Bassett

In my application I need to pass a parameter to Stephen Lebans' great
product so I can create individual PDFs for students based on their ID. The
report (more correctly, the underlying query) accepts the ID as a
parameter, so ideally I would run a query to get the list of students and
loop through that list, passing each student's ID to the subroutine which
runs the report. This code below which works when prompting for the ID does
not show an option to pass any parameters which I need to automate the
process:

DoCmd.OutputTo acOutputReport, RptName, "SnapshotFormat(*.snp)",
strPathandFileName

Any help is appreciated. I'm sure it's easy to get this to support
parameters.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with DoCmd.OutputTo snapshot with subreport in ReportToPDF 2
Help with Code 1
pass query parameter value to report 8
Pass parameter value to sub report query 3
Pass Parameter to Sub-Report 4
How to pass a parameter for a report query? 1
Report based on parameter query 16
Using a query parameter for a report 8

Top