Multiple Report Printing

[jesusoneez]

I have six reports which I have to print for six people. Each reports takes a start and end date (usually just todays date), and the reports show various information about the days production, sales, deliveries blah de blah.

Currently, I push a button for each report and input the date...I have to do this five times for each of the six reports...boring? Yes.

{First question, when I click the button, and input the date, how can I tell it to print six copies by default?}

EDIT
------

First question is solved...but if anyone can answer the second question, I'd be pleased as pie.

Second question, all six reports require the same date...how can I pass that date automatically to all the reports so I don't get RSI typing the same thing over and over...

...Here's the possible clincher...the dates are not in any Access known Date format. They come from an old Mainframe system that stores dates like 20021025 (October 25th 2002).

Any ideas welcomed with open arms and sloppy kisses.

Regards,

Steve

 

[pdx_man]

You need to create a form where you will enter the date and print the reports from. Remember that you can change the format of dates in Access using the Format function. Format[MyDate], "YYYYMMDD"). So if the user enters it "10/25/02", you can use this function to straighten it out.

Check this thread out:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=16360

 

[jesusoneez]

You are a star...I didn't know about that function.

Thanks!

Ste