print or preview

M

Martin Hopkins

Hello,

I have a report that is run by a marco from a form using the crireria that
the user enters. All works very well and the report goes direct to the
printer.

But on some reports I need to ask the user if they wish to print or preview
the report.

How is this done through a macro or form?

Any help gratefully received

Martin Hopkins
 
C

Cathy

Martin,

I'm assuming you are using runcommand.print. Your solution may be as simple
as providing a second button with runcommand.printpreview attached.

Cathy
 
S

Steve Schapel

Yes, that's pretty much the approach I would take. Having two buttons,
I mean, one for print and one for preview. But I don't think you would
be using a RunCommand action. In both cases, the macro would be a
OpenReport action, with its View argument set to Print or Print Preview
as applicable.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print or Review 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Problem with Report and Forms 2
prient preview okay but actual printing causes #name? error 5
Report base on a query from a form? 8
Print a report without displaying print preview 1
Obtain report page count with out previewing the report. 2
Closing Access While Form Is In Print Preview Does Not Trigger Form Unload Event 3

Top