I just saw Dians
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 dont 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 doesnt 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.