Access Reports and Macros or Filters

[pattyjean]

I have developed 5 separate reports from 5 different queries and I made 1 macro to output the reports into pdf format on my local drive.

I was going to add prompts to the queries to let others pull the years they need but then they would have to run the macro and enter the Year into the prompt 5 times.

Is there a way I add a filter somewhere that they would only have to run the macro and filter once?

Thank you in advance for any suggestions.

 

[dhookom]

faq701-6763 IMO,always use controls on forms for all user interaction.

Duane
Hook'D on Access
MS Access MVP

 

[pattyjean]

Thanks Duane - I did read that FAQ and that is why I don't want to use prompts for the reports. Is there an easy way to run the macro for 5 reports to select the same year data?

 

[dhookom]

I don't use macros. There are lots of methods for setting a filter on a report. I typically use the WHERE CONDITION of the DoCmd.OpenReport method. You can also enter a reference to a control in the report's record source query criteria.

Do you have a form open that can host a control for selecting the appropriate year(s)?

Duane
Hook'D on Access
MS Access MVP

 

[pattyjean]

I have a form that houses the macros to run the reports and output them to my local drive. I have 4 macros that run about 20 reports.
If I do the open report command will I have to separate all the reports?

 

[dhookom]

Macros have the option of setting a Where Condition. This could be something like:
[tt][blue]
[YearField]=Forms!frmYourFormName!txtYear
[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP