Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    4

    Unanswered: auto export report to .SNP?

    Hi,

    I am new to this forum and would love to get some help from you....Thanks

    I am using/programming with Access 2000.
    Is there a code where I can auto export a report to .snp? I understand anyone can export a report MANUALLY, but, I'd like the program to export a report automatically, just like docmd.transfertext for .txt .....

    Thanks in advance for your help

    HamsterGirl

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    DoCmd.OutputTo acOutputReport, "reportname", "Snapshot Format", "DrivePathFileDOTsnp"

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jul 2004
    Posts
    4
    Izy:

    I tried the following

    Docmd.OutputTo acOutputReport, "rTransRpt", ".snp", "C:\test.snp"

    It gave me error:
    ======================
    Run-time error '2282':

    The formast that enable you to output data as Microsoft Excel, rich-text forma, MS-DoS text, or HTML file are missing from the Windows Registry
    ======================

    What did I do wrong?



    Quote Originally Posted by izyrider
    DoCmd.OutputTo acOutputReport, "reportname", "Snapshot Format", "DrivePathFileDOTsnp"

    izy

  4. #4
    Join Date
    Jul 2004
    Posts
    4
    Izy:

    I just found out I do need to put the words: "Snapshot Format" instead of ".snp"

    Thanks a lot, you are great!!!


    Quote Originally Posted by HamsterGirl35
    Izy:

    I tried the following

    Docmd.OutputTo acOutputReport, "rTransRpt", ".snp", "C:\test.snp"

    It gave me error:
    ======================
    Run-time error '2282':

    The formast that enable you to output data as Microsoft Excel, rich-text forma, MS-DoS text, or HTML file are missing from the Windows Registry
    ======================

    What did I do wrong?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •