RE: pdf file per record creation from form

Use this document:
http://partners.adobe.com/public/developer/en/acrobat/sdk/pdf/pdf_creation_apis_and_specs/DistillerAPIReference.pdf
This describes (bottom of page 20) how to set the destination path and
filename by setting a registry key. This key will be active for the next
document that is printed to the Adobe PDF printer.

The complete process would look like this:

set the registry key
print to the Adobe PDF printer
open the PDF file with the code that you already have so that you can modify
it.


Make sure that your report has the pdfwriter as default printer and you have
to set the registry key before calling the docmd.openreport for each record.

--
- Raoul Jacobs

The nature of developping is sharing knowledge.


"gg" wrote:

> Cold you be more specific, show essential code. It seems to me that I have
> to use send keys if i don't want each record print to stop for a dialog box
> I can easily change the form to a report. I am printing a record, not the
> screen.
>
> Also, is there something about code that I don't know that would allow the
> system to loop correctly for a dozen or so, then quit printing while still
> cycling through the loop?
>
> "JaRa" wrote:
>
> > Are you trying to print a screen/form or a report?
> >
> > Because if it's a report then you can automate the whole thing.
> > By printing it to the PDF Writer e.g. for adobe you can print automatically
> > by setting the filename of the file before printing in the registry.
> >
> >
> > --
> > - Raoul Jacobs
> >
> > The nature of developping is sharing knowledge.
> >
> >
> > "gg" wrote:
> >
> > > I am trying to save each record in a form, call it frmData, as a separate pdf
> > > file with a name corresponding to a field on the master form. The purpose is
> > > put pdf data on a web site with each pdf record accessible as a separate file.
> > >
> > > Without getting into detail, I do this:
> > >
> > > From the master form- I rename frmData to match field on master, say FieldName
> > > Open form FieldName
> > > SendKeys "%(f)pa~%(s)" to print to adobe
> > > Close form FieldName
> > > Rename FieldName back to frmData
> > > Goto next record on master from (source of next Fieldname)
> > > Loop until last record
> > >
> > > My problem is that it works fine on my computer (w2000 access 2000) but on
> > > one user's computer, (xp, w2003), it will print the first 10 or so records,
> > > then cycle all the way to the end withou printing any more files. Is there a
> > > better way to do this? If not, do I have to do something different for
> > > Access 2003?
> > >
> > >
.

Relevant Pages

  • 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: pdf file per record creation from form
    ... named pdf files. ... a report or form to a separate pdf file, ... > filename by setting a registry key. ...
    (microsoft.public.access.formscoding)
  • 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: pdf file per record creation from form
    ... > filename by setting a registry key. ... > document that is printed to the Adobe PDF printer. ... >> I can easily change the form to a report. ... I am printing a record, ...
    (microsoft.public.access.formscoding)
  • Re: Print an Access report to PDF thru automation
    ... 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. ... 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. ...
    (microsoft.public.access.modulesdaovba)