filter for printing multiple reports

[nanny]

I found some wonderful advise on printing multiple reports (edit code behind print button), but I need to take it a step further. I need to add a date range for the reports to print. I did this in the query under [AuditDate] and it's fine when I print one report, but when using the print all button it prompts me for a date range for each report (there are about 14, yes fourteen, to print). I am self taught and do not know how to write code. I know what I need to tell the computer--just not how .

 

[boblarson]

You need to use a form to enter the date and then keep the form open (although it can be hidden if you wish) and refer to the form's text box for the date instead of an input parameter.

See here for a sample that might help a bit:
http://downloads.btabdevelopment.com/Samples/dates/ReportAndForm.zip

 

[nanny]

Mr. Larson will I need to replace any of your expression with my information??? Do I need to start from a table then query then form??? Between [Forms]![frmReportDates]![txtBegDate] And [Forms]![frmReportDates]![txtEndDate]

 

[boblarson]

You can create a form named frmReportDates (or just import the one I have in the sample) and then you want to substitute the expression Between [Forms]![frmReportDates]![txtBegDate] And [Forms]![frmReportDates]![txtEndDate] for the criteria for [AuditDate] in the query/queries that you are using.

 

[nanny]

I copied your example, but the open report only let me choose one report to open/print. I was hoping to print all reports that fall within a date range.

 

[boblarson]

All you have to do is to modify the code to open the reports you want:

With DoCmd
   .OpenReport "rptReportTest", acViewPreview
   .OpenReport "YourNextReport", acViewPreview
   .OpenReport "YourThirdReport", acViewPreview
   .OpenReport "YourFourthReport", acViewPreview
End With

 

[nanny]

I understand--thanks, but do I have to open the reports before I can print them??

 

[boblarson]

I understand--thanks, but do I have to open the reports before I can print them??

No, if you just want them to print change the acViewPreview to acViewNormal

 

[nanny]

Still not working. I copied and pasted your code and then substituted my form names as appropriate. Do I need to create a query of the audit dates? Thanks again for your help--not a lot to work with on this end--even so----Thank you.
nanny

 

[nanny]

Hello again Mr. BobLarson
I finally got the reports to print using your form and modifying the code. I have 14 reports total that print. The only problem I am having now is three of the reports do not print the data they are suppose too. Any Ideas??? Thanks for your help.
Slow but Sure-----Nanny

 

[boblarson]

Unfortunately I wouldn't have a clue. And right now I just don't have the time to be looking at the actual database.

 

[nanny]

I went back and looked at all my reports. The dates on the three reports were not formatted the same as all the other reports. Correcting that made all the reports print correctly. You have been a great help and I appreciate it.

 

[boblarson]

I went back and looked at all my reports. The dates on the three reports were not formatted the same as all the other reports. Correcting that made all the reports print correctly. You have been a great help and I appreciate it.

 

[shenty]

Bob,

I have been after something like this myself and stumbled across this thread. Great....but one question.....

If i wanted the "End Date" to default to today then i put =Date() in the default value property, this works OK....

..but if i wanted the "Beginning Date" to default to the earliest date available in a particular query then how would i do that ?

Thanks in advance for any help.

John

 

[gemma-the-husky]

bob isnt here anymore

simplest way is just to say

startdate=0

you dont need to find out what the earliest date actually is.

 

[shenty]

ok m8 thanks anyway.......