Snapshot viewer and Access 97 reports And Emailing

[Salad]

Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?

[MLH]

<Big Snip>
PDF995 - a swell solution.

If so, any recommendations on a PDF program...preferably cheap?

[polite person]

On Thu, 22 Sep 2005 23:40:00 GMT, Salad <oi*@vinegar.com> wrote:

Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?

Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).

[MLH]

I'm looking for something to convert a pdf to a BMP or other file
format that makes A97 happy. Haven't found anything as of yet.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).

[Salad]

polite person wrote:

On Thu, 22 Sep 2005 23:40:00 GMT, Salad <oi*@vinegar.com> wrote:

Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?

Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.

The problem is that the Snapshot viewer can't handle large
images/pictures. Maybe it's good for thumbnails but it's not made for
any time of productions work.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).

Yes, cutePDF works. I was hoping there was a way one could pass to it
the folder/file name. I doubt it would take anyone anytime at all, that
wrote cutePDF, to look for a file in it's current directory and if it
existed, write to the folder directory found in that text file.