By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Export a report to SNP format by vba

P: n/a
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
Oct 7 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
<Ca*********@hotmail.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.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
Oct 8 '08 #2

P: n/a
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" <to*************@cox.netskrev i en meddelelse
news:lj********************************@4ax.com...
On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
<Ca*********@hotmail.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.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

Oct 11 '08 #3

P: n/a
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
Oct 12 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.