Send To Recipient -> Snapshot

[Bill]

Whenever I create a report with print preview and
subsequently use "Send To" -> "Email Recipient"
using the "Snapshot" format, the snp file shows
page footing totals are doubled from what was
seen in the print preview.

Any way to get around that problem?

Thanks,
Bill

 

[Larry Linson]

How are your "page footing totals" created? If in code, the event in which
the code is executed may be fired twice for the actual print than for the
print preview... that is a drawback of calculating in event code in Reports.
If you create those totals some other way, please clarify, and perhaps
someone can make a useful suggestion.

Larry Linson
Microsoft Office Access MVP

 

[Bill]

The "page footing totals" are in fact accumulated in code. I'll
re-visit the code tomorrow to see if I can trap exactly what
might be happening.

Stay tuned.

Thanks,
Bill

 

[Bill]

I'm not sure how to get around this problem, in that
some yes/no fields within a given record are being
tallied in code and inserted into an unbound text box.
Then, those tallies are accumulated in a temporary
variable that is made visible only on the last page of
the report in the "footer section" of the last page.

As I posted initially, the report preview is correct.
But, any subsequent printing or use of "Send To"
results in doubled or otherwise strangely totaled
values.

If I could somehow zero the accumulator after the
last page is formatted, then perhaps a recreation
of the report for printing or "Send To" would once
again produce the correct totals.

Any thoughts on how to essentially "re-initialize"
the accumulator variable?

Thanks,
Bill