Re: Print an Access report to PDF thru automation

Tech-Archive recommends: Fix windows errors by optimizing your registry

I haven't personally dealt with code that forces a report to print to a specific printer, but I have seen it done and discussed multiple times. If I understand it correctly, when Adobe Acrobat is installed it creates a printer with a PDF designation indicating that that 'printer' will send the document to a PDF file. So its not really a matter of printing to PDF so much as printing to a specific printer.

kate winn wrote:
Hello,
I've looked at many help listings and I can't seem to find an accurate solution. I need help! I'm tyring to print a report to a PDF thru a macro. So, I don't want to see the selection box it should be automated. I need to know how to do this via VBA, or another way if anyone knows. Can anyone help? Thanks 
.

Relevant Pages

  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: text (file) report to something newer
    ... moved over to VB6 but the report has remained basically unchanged ... report with the printer object which for the most part it looks ... Using a RichTextBox control in conjunction with the VB Printer Object is a good way of including different fonts and styles in your various lines and / or paragraphs of text, and you can print the contents of the RichTextBox anywhere you like on the page and over multiple pages, with whatever margins you wish and even in "newspaper style" columns if you want to, although it does take a fair amount of code to get the printing side of it right. ... that generating a PDF is easy using a standard PDF Printer. ...
    (microsoft.public.vb.general.discussion)
  • Re: Serviced Component : Architectural revival
    ... Q. Did you tried to wrote test of generating pdf by means of any other tools, ... Our client have Crystal Report license and they export it in Excel ... Placement of Dataacess layer to other machine. ... Can serviced components help us out under such circumstances? ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Printing local in a client-server web environment
    ... decides which lines are printed with the report. ... missing, the gridlines that are actually printed vary on each page. ... indeed there is no way to print PDF with .NET BCL. ... > approach I have found for printing is to avoid PDF all together and use ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Create macro which automaticallly creates PDF of a report
    ... It will automatically convert a report into a pdf file. ... when the macro is executing. ... function that then runs the desired VBA code. ...
    (microsoft.public.access.reports)