Automating a bunch of reports?? with parameters??

  • Thread starter Thread starter Brainwave Surfer
  • Start date Start date
B

Brainwave Surfer

Dear Internet Gang,

I have a user with a bunch of reports that they do every 2 weeks,

half of 'em just click and print...

half need a 4-digit number for a subset to print..


now, any way to automate this mess? in other words, to reduce the amount
of clicking, entering, etc.

they would like to keep the ones that need input to be one form, since
they change a lot..

thanks people, for any and all answers, hints, etc...

Jim
 
Jim,

The use of a Macro would do what you want. Then set each
of the Macros to a button on say a reporting form. The
Macro can be set to prompt for the input information then
do the report with that stored info.

You should be able to reduce this to point and click, for
each report, In the macro prompt user for input of 4
digits. then off it goes. Not to difficult if you have
used the Macro builder before.

Kevin
Taurus Power & Controls
 
Kevin,

so I could make a form with button(s) on it, and associate a macro such
that it could invoke other buttons that then call that report, and when
it's needed, just hard-code (only 5 diff. numbers) those 5 choices in,
and do 25-odd reports at one go..

am i on the right track so far? Thanks so much for that hint!!

Jim
 
Back
Top