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.
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.