Hi all.

my tool writes recordsets to a word document table

for now the word document is visible - when I am ready with my tool I intend
to set the visible property to false
but then I should have a command telling word that it should print the
document just completed twice

for now it doesn't even print at all.
it just opens up I can see all my various data stuff put on the right place
but have to go to word and use the menue to print

can I automate this ??? - how ???

Thanks for your time & help in advance,
Gina

Hi Gina,

Assuming you have an object reference to the Word document, all you need
do is call its PrintOut method.



On Sun, 6 Mar 2005 12:01:13 +0100, "Gina" <(E-Mail Removed)> wrote:

>Hi all.
>
>my tool writes recordsets to a word document table
>
>for now the word document is visible - when I am ready with my tool I intend
>to set the visible property to false
>but then I should have a command telling word that it should print the
>document just completed twice
>
>for now it doesn't even print at all.
>it just opens up I can see all my various data stuff put on the right place
>but have to go to word and use the menue to print
>
>can I automate this ??? - how ???
>
>Thanks for your time & help in advance,
>Gina
>

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

John.

Thanks,
I found out when I call the save method it works as well.
But then I would have to save all these docs which are no longer needed
after a user has done some amendments to it and of course printed it out how
many copies the user decides.
I just want to let the user do whatever he wants in an open word environment
and the current document visible in word created by my vba tool .

that seems to cause a problem for some strange reason

Gina

"John Nurick" <(E-Mail Removed)> schrieb im Newsbeitrag
news:(E-Mail Removed)...
> Hi Gina,
>
> Assuming you have an object reference to the Word document, all you need
> do is call its PrintOut method.
>
>
>
> On Sun, 6 Mar 2005 12:01:13 +0100, "Gina" <(E-Mail Removed)> wrote:
>
> >Hi all.
> >
> >my tool writes recordsets to a word document table
> >
> >for now the word document is visible - when I am ready with my tool I
intend
> >to set the visible property to false
> >but then I should have a command telling word that it should print the
> >document just completed twice
> >
> >for now it doesn't even print at all.
> >it just opens up I can see all my various data stuff put on the right
place
> >but have to go to word and use the menue to print
> >
> >can I automate this ??? - how ???
> >
> >Thanks for your time & help in advance,
> >Gina
> >
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.

Hi all.

Thanks to JaRa's example code, I changed it a bit and created a ref to New
Word.Application

Set DC = GetObject(wrd.ActiveDocument)

set it later on to wrd.quit
set wrd = Nothing

all works .... now I can go shopping ;-))

Thanks guys!!!!! for all your help and for your time!!

Gina

"Gina" <(E-Mail Removed)> schrieb im Newsbeitrag
news:d0pgso$95f$04$(E-Mail Removed)...
> John.
>
> Thanks,
> I found out when I call the save method it works as well.
> But then I would have to save all these docs which are no longer needed
> after a user has done some amendments to it and of course printed it out
how
> many copies the user decides.
> I just want to let the user do whatever he wants in an open word
environment
> and the current document visible in word created by my vba tool .
>
> that seems to cause a problem for some strange reason
>
> Gina
>
> "John Nurick" <(E-Mail Removed)> schrieb im Newsbeitrag
> news:(E-Mail Removed)...
> > Hi Gina,
> >
> > Assuming you have an object reference to the Word document, all you need
> > do is call its PrintOut method.
> >
> >
> >
> > On Sun, 6 Mar 2005 12:01:13 +0100, "Gina" <(E-Mail Removed)> wrote:
> >
> > >Hi all.
> > >
> > >my tool writes recordsets to a word document table
> > >
> > >for now the word document is visible - when I am ready with my tool I
> intend
> > >to set the visible property to false
> > >but then I should have a command telling word that it should print the
> > >document just completed twice
> > >
> > >for now it doesn't even print at all.
> > >it just opens up I can see all my various data stuff put on the right
> place
> > >but have to go to word and use the menue to print
> > >
> > >can I automate this ??? - how ???
> > >
> > >Thanks for your time & help in advance,
> > >Gina
> > >
> >
> > --
> > John Nurick [Microsoft Access MVP]
> >
> > Please respond in the newgroup and not by email.
>
>