Access Report to Postscript File

Is it possible to save an Access report to a Postscript file?  If so, can you then append another report to the same file?  
LVL 1
critter017Asked:
Who is Participating?
 
xSinbadConnect With a Mentor Commented:
As the postscript file is in binary format I daubt very much you could append another report to it and still be able to use it afterwards.

Code to print is like this;

link http://www.vb-helper.com/HowTo/printtxt.zip

or

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long


Call ShellExecute(hwnd, "Print", ("C:\Textfile.txt"), "", App.Path, 1)

Are you familiar with the Open for in VB like this to merge two files;

Private Sub MergeFiles(file1 As String, file2 As String)
  Dim abFile() As Byte
  Open file1 For Binary As #1
  Open file2 For Binary As #2
  ReDim abFile(LOF(2) - 1)
  Get #2, , abFile
  Put #1, LOF(1) + 1, abFile
  Close #1
  Close #2
End Sub



0
 
xSinbadCommented:
You can(I think) print it to a postscript file.

Install a new printer for your device and change the port option to FILE.
0
 
critter017Author Commented:
Assuming that it works that way, can I then use VB to append a second report to the first using the same file?  What would the VB code look like?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Richie_SimonettiIT OperationsCommented:
Another way is install a "vistual" PS printer driver and send report to it like you normally do when use print methods.
0
 
Computer101Commented:
A request for deletion has been made.  The questioner stated no comments helped.  I will await feedback before any action taken.

Computer101
E-E Admin
0
 
xSinbadCommented:
critter017 if you give some feedback on the code I gave you I may be able to help....
0
 
Computer101Commented:
critter,
Response?

Computer101
E-E Admin
0
 
critter017Author Commented:
Gave up trying.
Awarded these points to clear this question.
0
 
xSinbadCommented:
Thanks for the C grade critter017!

Maybe if you supplied some feed back to the problems you post people will be able to better help you.
0
 
Computer101Commented:
Based on the grade guidelines and no feedback, grade changed.

Computer101
E-E Admin
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.