Solved

Access Report to Postscript File

Posted on 2002-07-18
10
254 Views
Last Modified: 2013-12-02
Is it possible to save an Access report to a Postscript file?  If so, can you then append another report to the same file?  
0
Comment
Question by:critter017
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 6

Expert Comment

by:xSinbad
ID: 7161680
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
 
LVL 1

Author Comment

by:critter017
ID: 7161683
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
 
LVL 6

Accepted Solution

by:
xSinbad earned 100 total points
ID: 7161786
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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 7162224
Another way is install a "vistual" PS printer driver and send report to it like you normally do when use print methods.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 7286541
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
 
LVL 6

Expert Comment

by:xSinbad
ID: 7290375
critter017 if you give some feedback on the code I gave you I may be able to help....
0
 
LVL 1

Expert Comment

by:Computer101
ID: 7390605
critter,
Response?

Computer101
E-E Admin
0
 
LVL 1

Author Comment

by:critter017
ID: 7397568
Gave up trying.
Awarded these points to clear this question.
0
 
LVL 6

Expert Comment

by:xSinbad
ID: 7403501
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
 
LVL 1

Expert Comment

by:Computer101
ID: 7431958
Based on the grade guidelines and no feedback, grade changed.

Computer101
E-E Admin
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) is among the most important applications that I run on my Windows computers. I use it every day, for nearly all of my document and photo scanning, as well as most of my…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Microsoft Office Picture Manager has a Picture Shortcuts pane that shows a list with the Recently Browsed folders. While creating my video Micro Tutorial here at Experts Exchange showing How to Install Microsoft Office Picture Manager in Office 2013…
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…
Suggested Courses
Course of the Month6 days, 11 hours left to enroll

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question