Report Select on a Form

[cacolon]

Hi all.

I have several reports that are run daily and I have to do them one by one. is there a way to make a form that invokes each report and give me the option of making the input of the report variables within the form itself? for example, date or date range and department, among other parameters.

Please help! Thanks!!!!!

 

[Uncle Gizmo]

You might find a technique I show in my blog here applicable.

Generate Multiple PDF Invoices in MS Access

 

[cacolon]

thanks for the information, but is not what I'm looking for....

to be more specific I'm looking to create a Menu/form in which the user can choose form a list of reports and that it can also input the parameters, such as date, department, etc. from the form using the date widget for example.

Thanks in advance for any wisdom that you can spare.

 

[Uncle Gizmo]

a form that invokes each report and give me the option of making the input of the report variables within the form itself?

I beg to disagree, the instructions contain a method where the information is stored in the form. The report gathers information from the form on its opening (Report On open Event) Sounds like it's exactly what you asked for.

 

[Uncle Gizmo]

You could create a form with a button for each individual report you open. This method suffers from the problem that if you add any more reports you have to programmatically change the database. In other words add a new button. A better approach is to have a combobox with the names of all of your reports in it. I'm certain there is code in the forum to show you how to automatically gather the names of reports into a combobox. You just need to do a bit of searching. Once you have got the combo box listing all the reports you can set it up so that when you select a row you use the after update event of the combobox to open the selected report. You will also need text boxes for your beginning and ending dates a combobox to select department. As the report opens its on Open event is triggered and in this on Open event you can have some code pointing back to the form.

The code would look something like:-

Form_frmRptParameters.txtStartDate
Form_frmRptParameters.txtEndDate
Form_frmRptParameters.cboDept.columb(1)

This is AIR CODE --- off the top of my head so to speak, I'm sure it is full of mistakes and might well be completely the wrong way to go about it! Not sure, without getting behind keyboard and having a go...

 

[cacolon]

Thanks for the info. I'll check it out and get back to you. thanks again!