K
Ken
I will describe the manual flow of events that I would
like to automate in a macro. I run a macro to open a
report and select data pertenant to a specific month.
When I run the macro, I am asked to Enter Parameter Value
(enter the month). I enter the month and the report opens
with multiple pages of data in Print Preview. I can then
print the report with File/Print and I save the new report
with File/SaveAs/Export. I give the new file a name and
it is saved as an Access report.
I'm sure there must be a way to save the newly created
report- populated with data- automatically (without having
to go through Print Preview and doing it manually), but I
can't figure out how to do it. I tried the Macro Output
To command, but that didn't seem to work either.
Suggestions would be appreciated. Thanks.
like to automate in a macro. I run a macro to open a
report and select data pertenant to a specific month.
When I run the macro, I am asked to Enter Parameter Value
(enter the month). I enter the month and the report opens
with multiple pages of data in Print Preview. I can then
print the report with File/Print and I save the new report
with File/SaveAs/Export. I give the new file a name and
it is saved as an Access report.
I'm sure there must be a way to save the newly created
report- populated with data- automatically (without having
to go through Print Preview and doing it manually), but I
can't figure out how to do it. I tried the Macro Output
To command, but that didn't seem to work either.
Suggestions would be appreciated. Thanks.