dbTalk Databases Forums  

Export a report to SNP format by vba

comp.databases.ms-access comp.databases.ms-access


Discuss Export a report to SNP format by vba in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Carl Hansen
 
Posts: n/a

Default Export a report to SNP format by vba - 10-07-2008 , 03:17 PM






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



Reply With Quote
  #2  
Old   
Tom van Stiphout
 
Posts: n/a

Default Re: Export a report to SNP format by vba - 10-07-2008 , 10:04 PM






On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
<Carl.Hansen (AT) hotmail (DOT) com> wrote:

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



Quote:
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


Reply With Quote
  #3  
Old   
Carl Hansen
 
Posts: n/a

Default Re: Export a report to SNP format by vba - 10-08-2008 , 03:02 PM



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" <tom7744.no.spam (AT) cox (DOT) net> skrev i en meddelelse
news:lj8oe4pqchl9csbisvms4ae24gv6ut0e4i (AT) 4ax (DOT) com...
Quote:
On Tue, 7 Oct 2008 22:17:11 +0200, "Carl Hansen"
Carl.Hansen (AT) hotmail (DOT) com> wrote:

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




Reply With Quote
  #4  
Old   
Rick Brandt
 
Posts: n/a

Default Re: Export a report to SNP format by vba - 10-12-2008 , 05:05 PM



Carl Hansen wrote:
Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.