Querie and Report

[nyrob609]

Good Morning,

I need to know if possible to create multiple queries or reports at the same time. We have large table that is updated monthly this report gets broken down manually by Manager (30 managers in total) hen email to each manager.

Report or query specs will never change only the data I could do this manually create and save query/report for each manager once but I was wondering if there was code that will create all the queries and reports at the same time.

Thanks

 

[Ranman256]

I have a form. In it is a list box of people to email. Name, EmailAddr.
Also is a combo box of reports.
and a Send button.

The btnSend_click will then scan the list of people and send them the report.
cboRpt

The report uses a query, this query looks at the list box as the manager in the criteria.
select * from table where [manager] = forms!frmRpts!lstMgr

So when the manager is selected, the report pulls ONLY that managers data.
then sends it via
DoCmd.SendObject acSendReport, cboRpt, acFormatPDF, lstMgr, , , cboRpt.Column(1), cboRpt.Column(2), False