2 Copies Printed

[LJG]

I have the following code that merges data from a form into a word document,
but for some reason it keeps printing 2 copies instead of just the one.This
is my code:

objword.ActiveDocument.PrintOut Background:=True
objword.ActiveDocument.PrintOut , , , , , , , 1
objword.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges

All seems ok, I have tried to set the value to 0 but I get a message
telling me I need to chose a number

Any tips welcome

 

[BruceM]

You should post your question in a Word newsgroup, I think. This newsgroup
is for Microsoft Access, a relational database program.

 

[LJG]

This is an access problem, that code is behind a button the merges the data
from access to word. The problem being it prints 2 copies rather than just 1

 

[Douglas J. Steele]

While you may be using Access to drive the printing, it's still a Word
method. There may be problems using PrintOut in Word that we're not aware
of, but that someone in the Word newsgroup can identify.

That having been said, seems to me that you're calling the PrintOut method
twice, so that it's only natural that you'd get two copies. What happens if
you remove the second call to PrintOut, or try:

objword.ActiveDocument.PrintOut Background:=True, Copies:=1
objword.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges

 

[wynne lindbergh]

I have the following code that merges data from a form into a word document,
but for some reason it keeps printing 2 copies instead of just the one.This
is my code:

objword.ActiveDocument.PrintOut Background:=True
objword.ActiveDocument.PrintOut , , , , , , , 1
objword.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges

All seems ok, I have tried to set the value to 0 but I get a message
telling me I need to chose a number

Any tips welcome

I just want to know if I can send email on this application...! (Have a Mac
0S 9)