p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: HowTo: Print report to file via VBA


Message #1 by tegrovesjr@r... on Fri, 21 Jun 2002 15:12:49
I need to print a report to file.  My goal is to copy this file to 
multiple printers via the File System Object.  The copy of the file part 
is working great.  But I've hit the wall trying to get these reports to 
print to a file via VBA code. 

Any Ideas.
Message #2 by "Amy Wyatt" <amyw@c...> on Fri, 21 Jun 2002 15:33:19
What kind of file are you planning to print to? Is it a txt, rtf, snp? In 
any case check out help on OutputTo or SendObject for code to create these 
types of files and store them or send them via email. Let me know if you 
need more help.

Amy

> I need to print a report to file.  My goal is to copy this file to 
m> ultiple printers via the File System Object.  The copy of the file part 
i> s working great.  But I've hit the wall trying to get these reports to 
p> rint to a file via VBA code. 

> Any Ideas.
Message #3 by "George Oro" <george@c...> on Sat, 22 Jun 2002 09:32:00 +0400
Amy,

I just posted Subject: Report to PDF, do you have any idea about this?
Please help...

George ;(


-----Original Message-----
From: Amy Wyatt [mailto:amyw@c...]
Sent: Friday, June 21, 2002 3:33 PM
To: Access
Subject: [access] Re: HowTo: Print report to file via VBA


What kind of file are you planning to print to? Is it a txt, rtf, snp? In 
any case check out help on OutputTo or SendObject for code to create these 
types of files and store them or send them via email. Let me know if you 
need more help.

Amy

> I need to print a report to file.  My goal is to copy this file to 
m> ultiple printers via the File System Object.  The copy of the file part 
i> s working great.  But I've hit the wall trying to get these reports to 
p> rint to a file via VBA code. 

> Any Ideas.

Message #4 by tegrovesjr@r... on Mon, 24 Jun 2002 15:51:07
I would like the postscript output that can be generated thru the print 
dialog box by clicking the "Print to File" check box.


> What kind of file are you planning to print to? Is it a txt, rtf, snp? 
In 
a> ny case check out help on OutputTo or SendObject for code to create 
these 
t> ypes of files and store them or send them via email. Let me know if you 
n> eed more help.

> Amy

> > I need to print a report to file.  My goal is to copy this file to 
m> > ultiple printers via the File System Object.  The copy of the file 
part 
i> > s working great.  But I've hit the wall trying to get these reports 
to 
p> > rint to a file via VBA code. 

> > Any Ideas.
Message #5 by "Amy Wyatt" <amyw@c...> on Mon, 24 Jun 2002 16:40:53
I don't know much about postscript output. I tried printing to a file from 
access and was unable to find an application that would open the report in 
the format that Access defaults to (which I am assuming is your postscript 
format). Sorry, maybe someone else has more experience with this default 
file format out of Access 2000.

Amy

> I would like the postscript output that can be generated thru the print 
d> ialog box by clicking the "Print to File" check box.

> 
>>  What kind of file are you planning to print to? Is it a txt, rtf, snp? 
I> n 
a> > ny case check out help on OutputTo or SendObject for code to create 
t> hese 
t> > ypes of files and store them or send them via email. Let me know if 
you 
n> > eed more help.

> > Amy

> > > I need to print a report to file.  My goal is to copy this file to 
m> > > ultiple printers via the File System Object.  The copy of the file 
p> art 
i> > > s working great.  But I've hit the wall trying to get these reports 
t> o 
p> > > rint to a file via VBA code. 

> > > Any Ideas.
Message #6 by tegrovesjr@r... on Mon, 24 Jun 2002 17:54:34
Thanks for taking a look.  

FYI, the postscript output is the same image that is seen in preview/print 
mode of the report.  The reason I'm trying to print to the file via VBA is 
so that VBA code can copy (broadcast printing) this file to multiple 
printers without the user having to print multiple times to multiple 
warehouse/factory printers. 


> I don't know much about postscript output. I tried printing to a file 
from 
a> ccess and was unable to find an application that would open the report 
in 
t> he format that Access defaults to (which I am assuming is your 
postscript 
f> ormat). Sorry, maybe someone else has more experience with this default 
f> ile format out of Access 2000.

> Amy

> > I would like the postscript output that can be generated thru the 
print 
d> > ialog box by clicking the "Print to File" check box.

> > 
>> >  What kind of file are you planning to print to? Is it a txt, rtf, 
snp? 
I> > n 
a> > > ny case check out help on OutputTo or SendObject for code to create 
t> > hese 
t> > > ypes of files and store them or send them via email. Let me know if 
y> ou 
n> > > eed more help.

> > > Amy

> > > > I need to print a report to file.  My goal is to copy this file to 
m> > > > ultiple printers via the File System Object.  The copy of the 
file 
p> > art 
i> > > > s working great.  But I've hit the wall trying to get these 
reports 
t> > o 
p> > > > rint to a file via VBA code. 

> > > > Any Ideas.

  Return to Index