Sending multiple reports with same parameters

  • Thread starter Thread starter Rick D
  • Start date Start date
R

Rick D

I am trying to send multiple reports with same parameters through a macro. I
can set everything up except that it asks for every reports parameters as it
goes to send it. Is there a way to do this through a macro maybe. If so how?
Is there another way I should be going on this? Any help would be greatly
appreciated.

Thanks
 
Use unbound form with unbound text boxes for parameter entry.
Refer to text boxes in criteria of query for report like this --
[Forms]![YourFormName]![TextBox1]

Open form, enter parameters, leave form open, run repports.
 

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

multiple parameter queries on opening form 1
Send a single report 8
Access macro: How to output 3 queries to 3 tabs in 1 Excel workboo 8
Emailing multiple reports in Access 0
Send Object (Access 2003) 1
Pass report parameter through a macro 5
send object using a maco--filter report 1
Parameter help 1

Back
Top