Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Print report using data field names

Discussion in 'Information Technology' started by max2great4u@gmail.com, Jul 28, 2006.

  1. max2great4u@gmail.com

    max2great4u@gmail.com
    Expand Collapse
    Guest

    I have a report which contains more than 100 pages, I need to know is
    there a way to print each individual page with a different name or i
    need to use a field name and save the printed file(PDF format) with the
    respective field name.
     
  2. Loading...

    Similar Threads Forum Date
    Footprints Of Guru Nanak In Sri Lanka History of Sikhism May 27, 2016
    Sikhism Preserving the Sikh heritage in Print Sikh Sikhi Sikhism Jan 12, 2016
    Guru Nanak's Foot-Prints in Baghdad's Sands Blogs Oct 22, 2015
    My Story Printed in Sikh Review Sept 2015 Issue Convert's Corner Oct 19, 2015
    Sakhis In The Footprints Of Guru Nanak... Redeeming Noorshah-the Magical Woman Of Kamroop History of Sikhism Mar 18, 2015

  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    <max2great4u@gmail.com> wrote

    >I have a report which contains more
    > than 100 pages, I need to know is
    > there a way to print each individual
    > page with a different name or i
    > need to use a field name and save the
    > printed file(PDF format) with the
    > respective field name.


    Access does not support printing the pages of a report separately. I'm not
    at all sure what you mean by "use a field name and save the PDF"?

    If you know what data you want on each "page," yes, it may be possible to
    code to print 100 separate reports. Or, it may be possible to manipulate the
    page numbers so each of the 100 pages is Page 1 or Page 1 of 1, so the 100
    pages appear to be separate reports. But 100 separate reports, I suspect, is
    the only way to generate 100 separate PDF files.

    Larry Linson
    Microsoft Access MVP
     
  4. max2great4u@gmail.com

    max2great4u@gmail.com
    Expand Collapse
    Guest

    Hi,

    I totally agree with what you say, what i need is if a report has 100
    invoices i need each invoice to be printed as a PDF file and it should
    be saved automatically with the respective invoice number, I know it's
    possible it's just that i'm not able to crack.

    Any help in this regard will be greatly appreciated


    Larry Linson wrote:

    > <max2great4u@gmail.com> wrote
    >
    > >I have a report which contains more
    > > than 100 pages, I need to know is
    > > there a way to print each individual
    > > page with a different name or i
    > > need to use a field name and save the
    > > printed file(PDF format) with the
    > > respective field name.

    >
    > Access does not support printing the pages of a report separately. I'm not
    > at all sure what you mean by "use a field name and save the PDF"?
    >
    > If you know what data you want on each "page," yes, it may be possible to
    > code to print 100 separate reports. Or, it may be possible to manipulate the
    > page numbers so each of the 100 pages is Page 1 or Page 1 of 1, so the 100
    > pages appear to be separate reports. But 100 separate reports, I suspect, is
    > the only way to generate 100 separate PDF files.
    >
    > Larry Linson
    > Microsoft Access MVP
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    <max2great4u@gmail.com> wrote

    > I totally agree with what you say,
    > what i need is if a report has 100
    > invoices i need each invoice to be
    > printed as a PDF file and it should
    > be saved automatically with the
    > respective invoice number, I know it's
    > possible it's just that i'm not able to crack.


    If it is possible to print "pieces" of the _same report_ as separate PDF
    files, it would have to be done in the PDF, or by post-processing the PDF.

    If you create a Report that prints one invoice, and can clarify how you want
    to select the invoices to be printed, perhaps someone could offer useful
    suggestions on how to print the multiple one-invoice reports as PDFs which
    will accomplish your purpose.

    My own use of PDF has been to have Adobe Acrobat installed as a printer and
    manually select it when printing from Report Preview mode.

    Larry Linson
    Microsoft Access MVP
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Win2PDF is one comercial product to autocreate PDF's
    There are several others
    see http://www.groupacg.com/

    Pieter

    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:ugd0UUuqGHA.2180@TK2MSFTNGP05.phx.gbl...
    > <max2great4u@gmail.com> wrote
    >
    > > I totally agree with what you say,
    > > what i need is if a report has 100
    > > invoices i need each invoice to be
    > > printed as a PDF file and it should
    > > be saved automatically with the
    > > respective invoice number, I know it's
    > > possible it's just that i'm not able to crack.

    >
    > If it is possible to print "pieces" of the _same report_ as separate PDF
    > files, it would have to be done in the PDF, or by post-processing the PDF.
    >
    > If you create a Report that prints one invoice, and can clarify how you
    > want to select the invoices to be printed, perhaps someone could offer
    > useful suggestions on how to print the multiple one-invoice reports as
    > PDFs which will accomplish your purpose.
    >
    > My own use of PDF has been to have Adobe Acrobat installed as a printer
    > and manually select it when printing from Report Preview mode.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
    >
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4285 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  7. max2great4u@gmail.com

    max2great4u@gmail.com
    Expand Collapse
    Guest

    I have Adobe Acrobat 6.0 Professional and it is selected has default
    printer, now i want to send each invoice number in loop and print that
    particualr invoice as one PDF file.
    any code in this regard will be of great usefull.

    Larry Linson wrote:
    > <max2great4u@gmail.com> wrote
    >
    > > I totally agree with what you say,
    > > what i need is if a report has 100
    > > invoices i need each invoice to be
    > > printed as a PDF file and it should
    > > be saved automatically with the
    > > respective invoice number, I know it's
    > > possible it's just that i'm not able to crack.

    >
    > If it is possible to print "pieces" of the _same report_ as separate PDF
    > files, it would have to be done in the PDF, or by post-processing the PDF.
    >
    > If you create a Report that prints one invoice, and can clarify how you want
    > to select the invoices to be printed, perhaps someone could offer useful
    > suggestions on how to print the multiple one-invoice reports as PDFs which
    > will accomplish your purpose.
    >
    > My own use of PDF has been to have Adobe Acrobat installed as a printer and
    > manually select it when printing from Report Preview mode.
    >
    > Larry Linson
    > Microsoft Access MVP
     

Share This Page