Using Snapshot format in Access 2010

Topic

New Reply

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.

Reply | Quote

Replies

Apparently the snp format is not available in 2010, try pdf.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote

I agree that is likely.
For example I have a number of apps that use the Stephan Lebans Convert to PDFcode. 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.

Reply | Quote

DoCmd.SendObject acSendReport, stDocName, acFormatPDF

Reply | Quote

Thanks to all for your help

Reply | Quote