Craig and Jeffrey, It still not working. It's probably my pc. The quickest solution I did is to create a macro in each Word to select/print only certain pages when it's called in Access.
Thanks a lot for all your help, Julius --- In [email protected], "Craig" <[EMAIL PROTECTED]> wrote: > 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/
