SNAPSHOT REPORTS 1

[jamie13]

I am trying to generate invoices in a snapshot format to send to clients. When i am writing to sendobject code i need to enter a format. What is the code for snapshot. I know for rich text format it is AcFormatRTF.
Thanks
Jamie

 

[WildHare]

I think it's acSNAP. IF not, try acSnapshot.

Jim

How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[jamie13]

neither of these work. Any other suggestions?

 

[WildHare]

acFormatSnap ???

I know I saw it someplace, because I used this in an app at a previous job. Let me look some more...

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[jamie13]

ok thanks

 

[evalesthy]

I think "DoCmd.OutputTo acOutPutReport, strDocName, "Snapshot Format", strFullFileName" will work. (Fill in your own variables).

 

[jamie13]

actually I just got the answer and the format code is
"SnapshotFormat(*.snp)"
including the quotes
Thanks
jamie

 

[WildHare]

Yeah - leave it to MS to have that one form different than all the others.... sheesh...

How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[scriverb]

WildHare, "SnapshotFormat(*.snp)" is correct and I struggled with that one for a while until I regressed back to creating a Macro where Snapshot is in the dropdown list for report output formats and then converting it to code.

What a way to find the answer.

Bob Scriver