Stop print preview when printing report Access 2007

[Sarella]

Hi,

I have a series of forms which have a "print" button attached to them which
when clicked prints out an assortment of reports.

Everything works fine, however what ever you print generates a print preview
which sits behind the popped up form window, and I need to stop this
happening as it prevents the next report from printing properly

I don't want to preview the form, only print it out. Is this possible, and
if so, how?

Many thanks

[Gina Whipp]

Sarella,

Since printing and previewing are seperate actions there must be something
in your code that says Preview. Can you copy/paste the code you are using
here?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Sarella" <Sar...@discussions.microsoft.com> wrote in message
news:A934BF0B-7FF5-4720...@microsoft.com...

[Sarella]

Hi Gina,

I'm a very basic Access user, so created the button using the button wizard
toolbar and selected the report options - print report choice, and then
picked the report I wanted it to print. This has embedded a macro to the on
click property which shows:

Action : Open report: Purchase Order Print Report for EDIT - CANCEL screen,
Report, , , Normal

RunCommand: Print.

When the OpenReport line is highlighted the fields at the bottom specifiy
Report name, view, filter name, where condition and window mode. I have
changed view from print preview to print, but this causes macro errors.

I'm sorry that this probably isn't very clear. do you have an email address
and I can send you a screen print?

Many thanks, much appreciated

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

Sarella,

For my eMail address please go my web page, there is a button located on the
*Home* page. I do not post my eMail in any newsgroup as it will harvested
by Spammers. As I don't use Macros once you send me the screen shot I will
go and open my Access 2007 to assist you.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Sarella" <Sar...@discussions.microsoft.com> wrote in message

news:ADE3C2B0-1D53-409D...@microsoft.com...

[Gina Whipp]

Sarella,

Change your macro to the below... Just copy paste on the Arguments line and
remove the RunCommand: Print line.

Purchase Order Print Report for EDIT - CANCEL screen, Print, , , Normal

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Sarella" <Sar...@discussions.microsoft.com> wrote in message

news:ADE3C2B0-1D53-409D...@microsoft.com...