If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Print off multiple reports based on combo box selection
I have built my first database which I use at work to provide numerous
different reports giving stockloss details for 350 of my shops. I have about 36 reports that I am able to run off giving details at individual store or district level. Each one of these reports has a parameter query as its source, which normally asks me to enter the year and month for the data I want. Each month I have to print a pack that contains about 25 of these reports. I have created a macro that does this but I have to enter the same year and month every time each report is going to be printed. Can someone point me in the right direction to negate the need to enter the same information every time these reports are printed. Ideally I would Like to produce a form that has a couple of combo boxes on it. 1) For the Year 2) For the Month The user could select the chosen combination click a button and the reports would print off. Thanks |
#2
|
|||
|
|||
On Mon, 30 May 2005 08:13:05 -0700, jademaddy
wrote: Each month I have to print a pack that contains about 25 of these reports. I have created a macro that does this but I have to enter the same year and month every time each report is going to be printed. Can someone point me in the right direction to negate the need to enter the same information every time these reports are printed. Ideally I would Like to produce a form that has a couple of combo boxes on it. 1) For the Year 2) For the Month The simplest way would be to use a Form reference as your criterion. Rather than a criterion such as [Enter year:], create a small unbound form named frmCrit. Put textboxes - or, better, combo boxes with valid years, months, and (if desired) other criteria - on the Form, and use =[Forms]![frmCrit]![cboYear] (for example, assuming you named the year combo cboYear) as a criterion. All of the reports will use the form for their criteria. If the reports differ only in the query criteria, you could make it all one multipage report using the report's Sorting and Grouping feature, but running multiple reports is probably just about as easy. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
set the print area print multiple tabs | veng | General Discussion | 5 | February 12th, 2005 07:01 PM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Filtering Records on a form using multiple combo boxes | Mark Senibaldi | Using Forms | 1 | June 17th, 2004 07:05 PM |
Filtering records using multiple combo boxes | Mark Senibaldi | Using Forms | 0 | June 17th, 2004 03:55 PM |