Export a report to SNP format by vba

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Carl Hansen
    #1

    Export a report to SNP format by vba

    Hi NG

    I try to export a report, by using the following code - it fails with
    errorcode: 2282

    DoCmd.OutputTo acOutputReport, "Faktura", acFormatSNP, stinavn & "\" &
    strName & ".snp", True

    if I write

    DoCmd.OutputTo acOutputReport, "Faktura", acFormatRTF, stinavn & "\" &
    strName & ".RTF", True

    It works perfect.

    Any ideas what I can do to make the Acformatsnp to work?

    TIA JJ


    Tags: None
    • Tom van Stiphout
      #2
      Re: Export a report to SNP format by vba

      On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
      <Carl.Hansen@ho tmail.comwrote:

      Can you create ANY .snp file, for example when you are previewing a
      report and then choose Send Email, and when prompted for a format
      choose Snapshot.
      If not, you have some installing to do.
      Can you repeat the behavior on other computers?

      -Tom.
      Microsoft Access MVP


      >Hi NG
      >
      >I try to export a report, by using the following code - it fails with
      >errorcode: 2282
      >
      >DoCmd.Output To acOutputReport, "Faktura", acFormatSNP, stinavn & "\" &
      >strName & ".snp", True
      >
      >if I write
      >
      >DoCmd.Output To acOutputReport, "Faktura", acFormatRTF, stinavn & "\" &
      >strName & ".RTF", True
      >
      >It works perfect.
      >
      >Any ideas what I can do to make the Acformatsnp to work?
      >
      >TIA JJ
      >

        Comment

        • Carl Hansen
          #3
          Re: Export a report to SNP format by vba

          Hi tom

          When I preview a report I can make a snp file by doing: File --Export and
          then choose snp in file type

          Best regards
          Henrik
          "Tom van Stiphout" <tom7744.no.spa m@cox.netskrev i en meddelelse
          news:lj8oe4pqch l9csbisvms4ae24 gv6ut0e4i@4ax.c om...
          On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
          <Carl.Hansen@ho tmail.comwrote:
          >
          Can you create ANY .snp file, for example when you are previewing a
          report and then choose Send Email, and when prompted for a format
          choose Snapshot.
          If not, you have some installing to do.
          Can you repeat the behavior on other computers?
          >
          -Tom.
          Microsoft Access MVP
          >
          >
          >
          >>Hi NG
          >>
          >>I try to export a report, by using the following code - it fails with
          >>errorcode: 2282
          >>
          >>DoCmd.OutputT o acOutputReport, "Faktura", acFormatSNP, stinavn & "\" &
          >>strName & ".snp", True
          >>
          >>if I write
          >>
          >>DoCmd.OutputT o acOutputReport, "Faktura", acFormatRTF, stinavn & "\" &
          >>strName & ".RTF", True
          >>
          >>It works perfect.
          >>
          >>Any ideas what I can do to make the Acformatsnp to work?
          >>
          >>TIA JJ
          >>

            Comment

            • Rick Brandt
              #4
              Re: Export a report to SNP format by vba

              Carl Hansen wrote:
              Hi tom
              >
              When I preview a report I can make a snp file by doing: File -->
              Export and then choose snp in file type
              What version of Access?

              --
              Rick Brandt, Microsoft Access MVP
              Email (as appropriate) to...
              RBrandt at Hunter dot com


                Comment

                Previous template Next
                Working...