Welcome to SPN

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

Sign Up Now!

Exporting Report as a Word Document

Discussion in 'Information Technology' started by Lateral, Jul 28, 2006.

  1. Lateral

    Lateral
    Expand Collapse
    Guest

    Hi guys

    I would like to have the ability to "export" any of my reports as a Word
    document such as having a "Save As" option etc.

    Is there an easy way to do this in Access 2003?

    Thanks
    Regards
    Greg
     
  2. Loading...

    Similar Threads Forum Date
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014
    Legal ACLU reports: Judge orders Sikh man, "Remove that rag, or Go to Jail! Breaking News Sep 27, 2013

  3. Baz

    Baz
    Expand Collapse
    Guest

    Tools menu--Office Links--Publish it With Microsoft Office Word.

    Note, however, that this in fact creates an RTF file, which will not
    necessarily appear as perfectly as you wish in Word. For best results, you
    should keep the layout and formatting of your reports as simple as possible.

    Another option, if you wish to send reports to people, is the Snapshot
    format (File menu--Export--Save As Type--Snapshot). However, this really
    sucks for many reasons. A much better idea is to use a cheapo PDF writer
    such as CutePDF or Win2PDF to "print" your reports as PDF files.

    "Lateral" wrote:

    > Hi guys
    >
    > I would like to have the ability to "export" any of my reports as a Word
    > document such as having a "Save As" option etc.
    >
    > Is there an easy way to do this in Access 2003?
    >
    > Thanks
    > Regards
    > Greg
     
  4. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    When previewing the report, try clicking on the "Tools" menu, then "Office
    Links", then "Publish It with MS Word" (I use Access 2000, so your menus may
    differ slightly).

    If your report is complex this may not work to your satisfaction, but it
    seems to work well for simple reports.

    -Michael



    "Lateral" wrote:

    > Hi guys
    >
    > I would like to have the ability to "export" any of my reports as a Word
    > document such as having a "Save As" option etc.
    >
    > Is there an easy way to do this in Access 2003?
    >
    > Thanks
    > Regards
    > Greg
     
  5. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi Baz.

    For outputting reports to .pdf, I've found nothing better than Stephen
    Lebans' "ReportToPDF". It works wonderfully without the need for any kind of
    separate PDF Writer. There is no messing about with changing printer drivers,
    and it is completely free of charge.

    You can find it here:
    http://www.lebans.com/reporttopdf.htm .

    -Michael


    "Baz" wrote:

    > Tools menu--Office Links--Publish it With Microsoft Office Word.
    >
    > Note, however, that this in fact creates an RTF file, which will not
    > necessarily appear as perfectly as you wish in Word. For best results, you
    > should keep the layout and formatting of your reports as simple as possible.
    >
    > Another option, if you wish to send reports to people, is the Snapshot
    > format (File menu--Export--Save As Type--Snapshot). However, this really
    > sucks for many reasons. A much better idea is to use a cheapo PDF writer
    > such as CutePDF or Win2PDF to "print" your reports as PDF files.
    >
    > "Lateral" wrote:
    >
    > > Hi guys
    > >
    > > I would like to have the ability to "export" any of my reports as a Word
    > > document such as having a "Save As" option etc.
    > >
    > > Is there an easy way to do this in Access 2003?
    > >
    > > Thanks
    > > Regards
    > > Greg
     
  6. Lateral

    Lateral
    Expand Collapse
    Guest

    Thanks for the prompt replies!

    When I run my application using the /runtime parameter, the "Tools" menu
    item does not appear. All I have is "File", "Window" and "Help".

    What have I forgotten to do?

    Regards
    Greg

    "Michael H" wrote:

    > Hi.
    >
    > When previewing the report, try clicking on the "Tools" menu, then "Office
    > Links", then "Publish It with MS Word" (I use Access 2000, so your menus may
    > differ slightly).
    >
    > If your report is complex this may not work to your satisfaction, but it
    > seems to work well for simple reports.
    >
    > -Michael
    >
    >
    >
    > "Lateral" wrote:
    >
    > > Hi guys
    > >
    > > I would like to have the ability to "export" any of my reports as a Word
    > > document such as having a "Save As" option etc.
    > >
    > > Is there an easy way to do this in Access 2003?
    > >
    > > Thanks
    > > Regards
    > > Greg
     
  7. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    You may have a corresponding toolbar button. Look for a blue "W". However,
    the button may also appear as a green "X" or a Notepad icon. If so, click
    the little arrow to the right of the button to see the other options.

    If you don't have this button on the toolbar, you may have to add your own
    custom toolbar containing this button. Either that, or don't run Access with
    that parameter, or output to PDF instead.

    "Lateral" wrote:

    > Thanks for the prompt replies!
    >
    > When I run my application using the /runtime parameter, the "Tools" menu
    > item does not appear. All I have is "File", "Window" and "Help".
    >
    > What have I forgotten to do?
    >
    > Regards
    > Greg
    >
    > "Michael H" wrote:
    >
    > > Hi.
    > >
    > > When previewing the report, try clicking on the "Tools" menu, then "Office
    > > Links", then "Publish It with MS Word" (I use Access 2000, so your menus may
    > > differ slightly).
    > >
    > > If your report is complex this may not work to your satisfaction, but it
    > > seems to work well for simple reports.
    > >
    > > -Michael
    > >
    > >
    > >
    > > "Lateral" wrote:
    > >
    > > > Hi guys
    > > >
    > > > I would like to have the ability to "export" any of my reports as a Word
    > > > document such as having a "Save As" option etc.
    > > >
    > > > Is there an easy way to do this in Access 2003?
    > > >
    > > > Thanks
    > > > Regards
    > > > Greg
     
  8. Lateral

    Lateral
    Expand Collapse
    Guest

    Thanks Michael,

    I had a look around and managed to figure out how to add the "Tools" item to
    the menu!

    Thanks again
    Regards
    Greg

    "Michael H" wrote:

    > Hi.
    >
    > You may have a corresponding toolbar button. Look for a blue "W". However,
    > the button may also appear as a green "X" or a Notepad icon. If so, click
    > the little arrow to the right of the button to see the other options.
    >
    > If you don't have this button on the toolbar, you may have to add your own
    > custom toolbar containing this button. Either that, or don't run Access with
    > that parameter, or output to PDF instead.
    >
    > "Lateral" wrote:
    >
    > > Thanks for the prompt replies!
    > >
    > > When I run my application using the /runtime parameter, the "Tools" menu
    > > item does not appear. All I have is "File", "Window" and "Help".
    > >
    > > What have I forgotten to do?
    > >
    > > Regards
    > > Greg
    > >
    > > "Michael H" wrote:
    > >
    > > > Hi.
    > > >
    > > > When previewing the report, try clicking on the "Tools" menu, then "Office
    > > > Links", then "Publish It with MS Word" (I use Access 2000, so your menus may
    > > > differ slightly).
    > > >
    > > > If your report is complex this may not work to your satisfaction, but it
    > > > seems to work well for simple reports.
    > > >
    > > > -Michael
    > > >
    > > >
    > > >
    > > > "Lateral" wrote:
    > > >
    > > > > Hi guys
    > > > >
    > > > > I would like to have the ability to "export" any of my reports as a Word
    > > > > document such as having a "Save As" option etc.
    > > > >
    > > > > Is there an easy way to do this in Access 2003?
    > > > >
    > > > > Thanks
    > > > > Regards
    > > > > Greg
     
  9. Baz

    Baz
    Expand Collapse
    Guest

    Didn't know about that, I'll check it out. Thanks!

    "Michael H" wrote:

    > Hi Baz.
    >
    > For outputting reports to .pdf, I've found nothing better than Stephen
    > Lebans' "ReportToPDF". It works wonderfully without the need for any kind of
    > separate PDF Writer. There is no messing about with changing printer drivers,
    > and it is completely free of charge.
    >
    > You can find it here:
    > http://www.lebans.com/reporttopdf.htm .
    >
    > -Michael
    >
    >
    > "Baz" wrote:
    >
    > > Tools menu--Office Links--Publish it With Microsoft Office Word.
    > >
    > > Note, however, that this in fact creates an RTF file, which will not
    > > necessarily appear as perfectly as you wish in Word. For best results, you
    > > should keep the layout and formatting of your reports as simple as possible.
    > >
    > > Another option, if you wish to send reports to people, is the Snapshot
    > > format (File menu--Export--Save As Type--Snapshot). However, this really
    > > sucks for many reasons. A much better idea is to use a cheapo PDF writer
    > > such as CutePDF or Win2PDF to "print" your reports as PDF files.
    > >
    > > "Lateral" wrote:
    > >
    > > > Hi guys
    > > >
    > > > I would like to have the ability to "export" any of my reports as a Word
    > > > document such as having a "Save As" option etc.
    > > >
    > > > Is there an easy way to do this in Access 2003?
    > > >
    > > > Thanks
    > > > Regards
    > > > Greg
     

Share This Page