Snapshot feature - maintaining margins in reports

A

Access101

We use Access's snapshot feature to make *.snp files of our reports. The
database is located on a server.

The reports are formatted as 11 X 17, SAVED as such, printed out CORRECTLY,
and then closed.

At a later date, either on my machine or on another user's machine, upon
viewing these reports in print preview, sometimes the text is bleeding off
the page, and I have to redo the page setup in order to get the 11 X 17
back--at which point I SAVE it yet again.

That's the first problem.

The other problem happens when I use the following VBA code to attach a
*.snp to email:

Call OutputSnapshotFile(intOutputTO, strName, strPath, strRecipName)

<First of all, let me say that the code itself works fine ... I end up with
an email that has the *.snp attached, and all the emails automatically added
that I had programmed in the code.>

When using the above VBA code to attach the *.snp to an email, and then
double click on the *.snp that was attached in the email, I ALWAYS end up
with the text bleeding off the snapshot report.

To avoid this, I can't use the code, but instead have to open the report
manually, format it to 11 X 17, SAVE it, and EXPORT it to a *.snp, and then
attach that *.snp file manually to an email.

Any help would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top