Snapshot viewer and Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janet - 07 Aug 2007 06:44 GMT

I cannot get Access 2007 to output to the snapshot viewer. I have the viewer
installed and the output to works fine from Access 2003 but not Access 2007.
I have uninstalled and reinstalled the viewer.

Any ideas what I need to do to get Access 2007 to recognize the snapshot
viewer?

Reply to this Message

Rick Brandt - 07 Aug 2007 12:33 GMT

> I cannot get Access 2007 to output to the snapshot viewer. I have
> the viewer installed and the output to works fine from Access 2003
> but not Access 2007. I have uninstalled and reinstalled the viewer.
>
> Any ideas what I need to do to get Access 2007 to recognize the
> snapshot viewer?

The Snapshot "Viewer" has nothing to do with the ability to create Snapshot
files. Usually problems like this are caused by missing registry entries, but
the newness of Access 2007 doesn't rule out other bugs that could be in play.

Does nothing happen or do you get an error?

Signature

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

Reply to this Message

Janet - 07 Aug 2007 16:34 GMT

DoCmd.OutputTo acOutputReport, "PayrollMaster", acFormatSNP,
"PayrollMaster.snp", True

genrates "The output to actionwas cancelled."

Also, when I try to export the report PayrollMaster, the Snapshot viewer is
not listed in the list of available export options.

I'm running both Office 2003 and Office 2007 on the same machine. No
problems with 2003 and the Snapshot viewer.

> > I cannot get Access 2007 to output to the snapshot viewer. I have
> > the viewer installed and the output to works fine from Access 2003
[quoted text clipped - 8 lines]
>
> Does nothing happen or do you get an error?

Reply to this Message

Janet - 07 Aug 2007 19:38 GMT

After working on this for a while, I found that by including a path in the
output filename, the OutputTo statement will work. If no path is included,
then the error is generated.

But .snp format is still not listed as an option when exporting a report.

> DoCmd.OutputTo acOutputReport, "PayrollMaster", acFormatSNP,
> "PayrollMaster.snp", True
[quoted text clipped - 19 lines]
> >
> > Does nothing happen or do you get an error?

Reply to this Message