Julius
I tested the following code fromm within Access and it worked. I am
certain some of it is over kill, but I took it from Word, brought
into Access and it worked!
WordObj.PrintOut FileName:="", Range:=wdPrintRangeOfPages, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="1,3", PageType:= _
wdPrintAllPages, ManualDuplexPrint:=False, Collate:=True,
Background:= _
True, PrintToFile:=False, PrintZoomColumn:=0,
PrintZoomRow:=0, _
PrintZoomPaperWidth:=0, PrintZoomPaperHeight:=0
--- In [email protected], "Jeffrey Hansler"
<[EMAIL PROTECTED]> wrote:
> You might try separating your print command lines
>
> WordObj.PrintOut Background:=True,Page:="1"
>
> ----- Original Message -----
> From: Craig Gross
> To: [email protected]
> Sent: Friday, August 26, 2005 2:14 PM
> Subject: RE: [AccessDevelopers] Re: Print Pages in Word and Print
TIFF files
>
>
> I just saw Dian's response to your question, and I am surprised
by the response. I was certain she would have an answer, mainly
because she is a Word MVP and I am not. Well then, that leaves us
with Access. I don't have time to figure this one out right now, but
hopefully someone within this group can figure it out. Though I find
it odd that it doesn't work from Access if it works from within Word.
Hmm, I wonder if it is a reference problem?!
>
>
>
> -----Original Message-----
> From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of uhitmiaysuu
> Sent: Friday, August 26, 2005 1:38 PM
> To: [email protected]
> Subject: [AccessDevelopers] Re: Print Pages in Word and Print
TIFF files
>
>
>
> Craig,
> Thank you very much. I will post it to that site. I am still
looking
> for some answers on my second question. If ever you'll find a
> solution to my problem, I appreciate it.
> Thanks,
> Julius
>
> --- In [email protected], "Craig Gross"
<[EMAIL PROTECTED]>
> wrote:
> > I understand this, but you are using the Word object library in
your
> > code, thus you are looking for Word VBA information. It doesn't
> matter
> > that you are building the code in Access. I write applications
all
> the
> > time from within Access where I open and work with Excel, Word
and
> even
> > PowerPoint. When I need to talk to those modules I seek help in
the
> > appropriate group. I do this because I have a better chance of
> finding
> > my answer in that particular group. You don't even need to
mention
> you
> > are using Access in these other groups. You only need seek the
> answer to
> > your question about printing pages from within Word. When you
get
> this
> > answer, you will be able to insert it into Access.
> >
> >
> >
> > The point is that your question is a Word VBA question, and I
am
> certain
> > someone in that group will have the answer. I am not saying
this so
> you
> > don't post to this group I say it to help you find the right
answer
> > quickly.
> >
> >
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
uhitmiaysuu
> > Sent: Friday, August 26, 2005 11:49 AM
> > To: [email protected]
> > Subject: [AccessDevelopers] Re: Print Pages in Word and Print
TIFF
> files
> >
> >
> >
> > Craig,
> > I am doing this in ms access not in word.
> > Thanks,
> > Julius
> >
> > --- In [email protected], "Craig Gross"
> <[EMAIL PROTECTED]>
> > wrote:
> > > You may want to ask this question in the Word VBA group.
> > > [EMAIL PROTECTED] As you are looking for Word VBA
> > information.
> > > They have a good group over there, and they should be able to
> answer
> > > question.
> > >
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: [email protected]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of
uhitmiaysuu
> > > Sent: Friday, August 26, 2005 10:50 AM
> > > To: [email protected]
> > > Subject: [AccessDevelopers] Print Pages in Word and Print
TIFF
> files
> > >
> > >
> > >
> > > Hi,
> > > I have 2 problems. First, I have a code to open a 24-page
word doc
> > > but I would like to print only pages 1, 7 and 24 as soon as
it
> > opens.
> > >
> > > sample:
> > > Dim WordObj As Object
> > > Set WordObj = CreateObject("Word.Application")
> > >
> > > WordObj.Documents.Open "C:\AT&T.DOC"
> > > WordObj.PrintOut Background:=True, Pages:="1,7,24" `this one
> > doesn't
> > > work, it prints out all 24 pages
> > > WordObj.Quit SaveChanges:=No
> > >
> > > Set WordObj = Nothing
> > > Question: how can I print specific pages only?
> > >
> > > My second problem is how to automatically print .TIFF file
> > > (hyperlink) when I click on the link.
> > >
> > > sample:
> > > Me.Package.SetFocus
> > > DoCmd.RunCommand acCmdOpenHyperlink
> > > DoCmd.PrintOut `this will print only the form and not the
tiff
> file
> > > Question: how to print it tiff file?
> > >
> > > I appreciate all your help.
> > > Thanks,
> > > Julius '2000 ver
> > >
> > >
> > >
> > >
> > >
> > >
> > > Please zip all files prior to uploading to Files section.
> > >
> > >
> > >
> > >
> > > _____
> > >
> > > YAHOO! GROUPS LINKS
> > >
> > >
> > >
> > > * Visit your group "AccessDevelopers
> > > <http://groups.yahoo.com/group/AccessDevelopers> " on the web.
> > >
> > >
> > > * To unsubscribe from this group, send an email to:
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]
> > subject=Unsubscribe
> > > >
> > >
> > >
> > > * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms
> > of
> > > Service <http://docs.yahoo.com/info/terms/> .
> > >
> > >
> > >
> > > _____
> > >
> > >
> > >
> > > This email and any attachments contain information from Baker
&
> > Taylor which may
> > > be confidential, privileged and/or protected by other legal
> rules.
> > If you are not the
> > > intended recipient, you are hereby advised that any
disclosure,
> > copying, distribution or
> > > use of the contents of this email is prohibited. If you have
> > received the email in error,
> > > please notify us by reply email immediately and then delete
the
> > email and your reply
> > > from your email system. NOTE: Baker & Taylor accepts no
liability
> > for the contents of
> > > this email. This email shall not operate to bind Baker &
Taylor
> to
> > any contract, order
> > > or other obligation.
> >
> >
> >
> >
> >
> >
> > Please zip all files prior to uploading to Files section.
> >
> >
> >
> >
> > SPONSORED LINKS
> >
> > Microsoft access database
> > <http://groups.yahoo.com/gads?
> t=ms&k=Microsoft+access+database&w1=Micros
> >
>
oft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access&
> w4
> >
>
=Microsoft+access+database+design&w5=Microsoft+access+database+trainin
> g&
> > c=5&s=163&.sig=TjCMMZaJBtroyAQ8dznVsQ>
> >
> > Microsoft access developer
> > <http://groups.yahoo.com/gads?
> t=ms&k=Microsoft+access+developer&w1=Micro
> >
>
soft+access+database&w2=Microsoft+access+developer&w3=Microsoft+access
> &w
> >
>
4=Microsoft+access+database+design&w5=Microsoft+access+database+traini
> ng
> > &c=5&s=163&.sig=oqhFqsmlUZ5Zh6pQgnvTDQ>
> >
> > Microsoft access
> > <http://groups.yahoo.com/gads?
> t=ms&k=Microsoft+access&w1=Microsoft+acces
> >
>
s+database&w2=Microsoft+access+developer&w3=Microsoft+access&w4=Micros
> of
> >
>
t+access+database+design&w5=Microsoft+access+database+training&c=5&s=1
> 63
> > &.sig=MMKzpewSlzpK714XaCARAQ>
> >
> > Microsoft access database design
> > <http://groups.yahoo.com/gads?
> t=ms&k=Microsoft+access+database+design&w1
> >
>
=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsoft+
> ac
> >
>
cess&w4=Microsoft+access+database+design&w5=Microsoft+access+database+
> tr
> > aining&c=5&s=163&.sig=ecBsMdKeZw8i4_1kkC6epA>
> >
> > Microsoft access database training
> > <http://groups.yahoo.com/gads?
> t=ms&k=Microsoft+access+database+training&
> >
>
w1=Microsoft+access+database&w2=Microsoft+access+developer&w3=Microsof
> t+
> >
>
access&w4=Microsoft+access+database+design&w5=Microsoft+access+databas
> e+
> > training&c=5&s=163&.sig=FHk4Yggbv_zB-TsXvHyeig>
> >
> >
> >
> >
> >
> > _____
> >
> > YAHOO! GROUPS LINKS
> >
> >
> >
> > * Visit your group "AccessDevelopers
> > <http://groups.yahoo.com/group/AccessDevelopers> " on the web.
> >
> >
> > * To unsubscribe from this group, send an email to:
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]
> subject=Unsubscribe
> > >
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo!
Terms
> of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> > _____
> >
> >
> >
> > This email and any attachments contain information from Baker &
> Taylor which may
> > be confidential, privileged and/or protected by other legal
rules.
> If you are not the
> > intended recipient, you are hereby advised that any disclosure,
> copying, distribution or
> > use of the contents of this email is prohibited. If you have
> received the email in error,
> > please notify us by reply email immediately and then delete the
> email and your reply
> > from your email system. NOTE: Baker & Taylor accepts no
liability
> for the contents of
> > this email. This email shall not operate to bind Baker & Taylor
to
> any contract, order
> > or other obligation.
>
>
>
>
>
>
>
> --------------------------------------------------------------------
----------
> This email and any attachments contain information from Baker &
Taylor which may
> be confidential, privileged and/or protected by other legal
rules. If you are not the
> intended recipient, you are hereby advised that any disclosure,
copying, distribution or
> use of the contents of this email is prohibited. If you have
received the email in error,
> please notify us by reply email immediately and then delete the
email and your reply
> from your email system. NOTE: Baker & Taylor accepts no liability
for the contents of
> this email. This email shall not operate to bind Baker & Taylor
to any contract, order
> or other obligation.
>
>
>
>
> Please zip all files prior to uploading to Files section.
>
>
>
> SPONSORED LINKS Microsoft access database Microsoft access
developer Microsoft access
> Microsoft access database design Microsoft access database
training
>
>
> --------------------------------------------------------------------
----------
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "AccessDevelopers" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
> --------------------------------------------------------------------
----------
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
