Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tad
Starting Member
31 Posts |
 Posted - 2002-06-21 : 10:08:35
|
| 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. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-06-23 : 19:12:09
|
Hi tadYes I have a few ideas...it all kind of depends on what your report looks like and whether it's an access report with lines, boxes, fonts etc etc, or whether you mean that all you want is the data...Forget the first option unless you have adobe acrobat and can "print to a .pdf"The second option is trivial, and depending on which version of Access you have, probably the easiest way is to export your data using Transferspreadsheet.HTH --I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
tad
Starting Member
31 Posts |
Posted - 2002-06-24 : 10:45:57
|
I am trying via VBA to print the Access report to the postscript file that the user can do thru the Access UI from the Print Dialog by clicking the "Print to File" check box, then providing a file name.quote:
Hi tadYes I have a few ideas...it all kind of depends on what your report looks like and whether it's an access report with lines, boxes, fonts etc etc, or whether you mean that all you want is the data...Forget the first option unless you have adobe acrobat and can "print to a .pdf"The second option is trivial, and depending on which version of Access you have, probably the easiest way is to export your data using Transferspreadsheet.HTH--I hope that when I die someone will say of me "That guy sure owed me a lot of money"
|
|
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-06-24 : 21:41:07
|
| Yep thought as much. I just tried it with ADOBE pdr writer as my default printer and it works a treat....All I can say is I've never got that to work printing to a postscript file (I'm not sure that Access really can do that)... So you've got two options - the transferspreadsheet method or adobeSorry for the bad news...PS - If you can get it to work - let me know I'd love to know how you did it.--I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 06/25/2002 02:49:15 |
|
|
|
|
|
|
HowTo: Print report to file via VBA