Stop print preview when printing report Access 2007

  • Thread starter Thread starter Sarella
  • Start date Start date
S

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
 
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
 
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,

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
 
Back
Top