Before I get too deep, I need advice about emailing reports...

[Guest]

Hello,

I’m in the middle of creating dashboard reports and while scanning this
message board for report solutions I happened upon some auto-email
discussions. My report is by store branch for which a form pops-up
requesting store #, month & year that gets passed to several queries to
create the report.

Now for the question: Is it possible to write VBA code to loop through the
store branches, prompting for month & year once – effectively ignoring the
form? Or should I create parallel queries/reports with parameters that don't
use a form for input?

Thanks for any advice. Best regards,

Allan

 

[REM7600]

I'd opt for VBA myself... The parallel queries/etc always end up being a
maintenance nightmare down the road when things "change"...

REM7600

 

[Guest]

Thanks for the reply, REM7600.

I don't think I clearly explained my situation. Currently to run a store
dashboard report, an access form prompts for the store #, etc. This works
fine when the finance staff needs to look at individual stores. But at month
end we'd like to send each store manager their relative report via email,
using VBA Code. However since the report/queries need input from the pop-up
form, can the code be written to bypass the form and instead have the fiscal
period/year requested once to apply to all stores?

I hope this helps clarify.
Thanks!

Allan

 

[Jim whitaker]

Look at a pdf driver.