Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using Snapshot format in Access 2010

    Is there a way in Access 2010 to use the Snapshot format in the following statement?

    DoCmd.SendObject acSendReport, stDocName, "Snapshot Format", ...

    I have found that in Access 2003 and Access 2007 this seems to work correctly. In 2010 the resulting file Report.snp throws an error when I try to open it.

    Would it be better to change the output to PDF?


    Thanks for any help.
    Richard

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Apparently the snp format is not available in 2010, try pdf.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Quote Originally Posted by Aheron View Post
    Is there a way in Access 2010 to use the Snapshot format in the following statement?

    DoCmd.SendObject acSendReport, stDocName, "Snapshot Format", ...
    Would it be better to change the output to PDF?
    The line of code still works, and the Snapshot format still exists, but they have removed the Snapshot Viewer from Access 2010.
    So yes, you are probably better of using PDF.
    Regards
    John



  4. #4
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,650
    Thanks
    38
    Thanked 161 Times in 139 Posts
    Quote Originally Posted by Access Blog
    In Access 2010, snapshot format for reports will not be available.

    As an alternative, you can export your reports to PDF/XPS and Excel formats instead. This is native functionality that doesn’t require a download.
    Source Access 2010 deprecated features and components
    Last edited by Browni; 2011-08-20 at 22:06. Reason: Tidy up quote

  5. #5
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    In Access 2010, snapshot format for reports will not be available.
    I know that they say it is not available, and you won't find it in the Menus etc, but they did not bother to actually remove it. All they actually removed was the Snapshot Viewer.
    Regards
    John



  6. #6
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,650
    Thanks
    38
    Thanked 161 Times in 139 Posts
    Possibly this is the precursor to removing snapshot support completely in the next version of Office and MS didn't want to totally break apps that currently use it.

    The source I used does suggest that there is a download available and IMHO MS are moving users off the snapshot format one step at a time.

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I agree that is likely.
    For example I have a number of apps that use the Stephan Lebans Convert to PDF code. That code actually makes a Snapshot then converts that to PDF. Fortunately that still works in 2010 (even though there are now easier ways to make PDFs) but you wonder whether it will still work in future.
    Regards
    John



  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can you help with the syntax for using the PDF. I had come to the conclusion that was the way to go, just having a hard time figuring out the correct syntax.


    Thanks for your help.
    Richard

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    DoCmd.SendObject acSendReport, stDocName, acFormatPDF
    Regards
    John



  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks to all for your help
    Richard

Posting Permissions

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