How to modify printing

[sierra]

How do I modify the printer selection in a report ?

I created a macro to run a query and then print a report.
This was set up for my own system.
I emailed a copy of this to a user at another location.

The report doesn't print out for him.
I presume that it's lloking for my local printer.

Where do I change the printer specification: in the
report, the macro or the query.
How can I default the report to display on screen and then
let the user decide if he wants to print ?

Thanks

 

[Rick Brandt]

How do I modify the printer selection in a report ?

I created a macro to run a query and then print a report.
This was set up for my own system.
I emailed a copy of this to a user at another location.

The report doesn't print out for him.
I presume that it's lloking for my local printer.

Where do I change the printer specification: in the
report, the macro or the query.
How can I default the report to display on screen and then
let the user decide if he wants to print ?

Select the report in the db window and then go to File - Page Setup. On the "Page"
tab of the resulting dialog make sure the report is set to use the "Default Printer"
rather than "Use Specific Printer". Then it will run using the default printer of
whatever user you send it to.

For a preview you need to add an argument to the OpenReport command

instead of...

DoCmd.OpenReport "YourReport"

....use...

DoCmd.OpenReport "YourReport", acPreview

 

[Sierra]

Rick:
Thanks for the quick response.
After fumbling around:
I viewed my macro in design view.
I clicked on the command 'OpenReport'
I changed the 'View' criteria from 'Print' to 'Print
Preview'

It worked.
Hey thanks, again.
I've just discovered this newsgroup, and it's great !!

MM Sierra