print multiple reports

[briandavis]

From a single button I would like to print out four seperate reports. Each report if printed individually will prompt the user for a date. The user will generally need to print all four reports and will always use the same date value for all four. How can I do this?

Thanks

 

[Malcy]

Hi
How about an unbound form, say frmReportDate with a textbox called, lets say txtReportDate that has format set to date.
Set the date on each report to be [Forms].[frmReportDate].[txtReportDate].
Then put a print report button on the form and call each report to print from the button_click.
You will probably need to work a few bits and pieces up but I think this would give you the bones. If you want a bit more just shout
Good luck

 

[briandavis]

SHOUT!

Where do I insert this [Forms].[frmReportDate].[txtReportDate].
I've done everything else but not sure where this goes.

 

[Malcy]

SHOUT!

Where do I insert this [Forms].[frmReportDate].[txtReportDate].
I've done everything else but not sure where this goes.

Well, you said you needed the same date for all four forms so you presumably print the date on the report (or am I mistaken).
If right, then instead of having an expression like Now() as the date, or whatever else you are using, then you would put (I think but you may have to play around a little) =[Forms].[frmReportDate].[txtReportDate]
Alternatively if you use the date as a criteria in the queries that build the report you would put [Forms].[frmReportDate].[txtReportDate] in the criteria line of the query or queries.
Provided the form is open when you call up the reports then it will pull in the date you put on the form.
Does this clarify?
Best wishes

 

[cippy]

can't run this action

hi forum,
i tried a similar thing but, the system hangs and the access message appears, " you cant run ..... ( something ) ..." and then ballon appears, asking to break code (something) .. I finally have to use crtl - alt-del. the buttons here open reports in preview. reports are as subrepots ( two on one ) ...
the same thing runs fine on another similar system ( although 128 mb ram )

please help

thanx in advance

cippy

 

[Malcy]

Hi cippy
It sounds like what Access does if you have got one of the names wrong somewhere. Either it cannot find one of the reports you have listed or else one of the queries that support the report.
Are you 100% certain that both instances are running EXACTLY the same database only it doesn't sound like a memory issue.
I sometimes get a similar thing and it is usually when VBA is asked to do something it cannot do (and it is usually a typo somewhere)
So my best advice would be to look through all your code to make sure that it can find and open every report and every query. Sometimes you have to go quite deep.
If you can open and print the reports manually then it is almost certainly a mis-spelling somewhere,
Hope this helps and good luck